Description
Specials and Promotions for Kids boutique Website :
How do you plan to create demand at low points in your sales cycle? Will you do buy one get offers? Have a subscription plan to stabilize revenue? The types of discounts and specials you plan to offer will affect the complexity of the eCommerce platform and subsequent development you need.
- About Us Page: for Kids boutique Website
- Indicate the information that will be in About Us page. What is supposed to be in that page?
- The ideas that will be in this page?
- Home page: for Kids boutique Website
- Indicate the information that will be in our home page. What is supposed to be in that page?
- Ideas that will be in that page?
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Here you go.I...
Completion Status:
100%
Review
Review
Anonymous
Really great stuff, couldn't ask for more.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
SDSU Roth IRA vs Traditional IRA Excel Sheet
PART II
You are a staff accountant at Anderson & Paul, a CPA firm located in downtown San Diego. A long-time cli ...
SDSU Roth IRA vs Traditional IRA Excel Sheet
PART II
You are a staff accountant at Anderson & Paul, a CPA firm located in downtown San Diego. A long-time client, Brady Patterson, has contacted you with a request. Brady is 52 years old and is currently in the 32% tax bracket. He is beginning to think about saving for retirement and has some questions. His employer does not offer a retirement plan so he is considering an IRA. However, he is confused about the differences between a Roth IRA and a Traditional IRA and needs your advice. He wants you to prepare an Excel spreadsheet that he can use to see the difference in a Traditional versus a Roth IRA.
Based on your discussion with Brady, the Excel model should cover a ten-year period. Brady would like to be able to change the following items in the model:
Year analysis begins
Amount of the IRA contribution (Note: only one contribution in this analysis – not one per year)
Tax rate at date of contribution (Note: assume the contribution is made on January 1 of the initial year)
Annual growth rate (Note: assume constant growth throughout the analysis period)
Tax rate at date of withdrawal (Note: assume the entire account balance is withdrawn at the end of the tenth year)
Prepare the model so that the above input variables automatically update the worksheet. This will allow Brady to test various assumptions and see the results of contributing to a Roth or a Traditional IRA.
The model should be based on a contribution only in the first year. Don’t build the model to have contributions every year.
The contribution should grow at the annual growth rate over a ten-year period. At the end of the ten years, the entire account balance is distributed to the account holder. The model should provide the net-of-tax amount the account holder will receive on distribution after the ten-year period and show the account balance each year.
Prepare one table showing the Roth IRA and one showing the Traditional IRA. Both tables and the input variable section should easily fit on a single page if set to print in landscape mode. Remember, a professional presentation includes proper titles and headings, is centered on the page when printed, and is a reasonable size on the page. Test the appearance of the worksheet by using the print preview function in Excel. Professional appearance is important so don’t overlook this part of the assignment.
The second page of your Excel model should be a graph showing the account balance at each year-end for the Roth and Traditional IRAs. The final year data point should be the net of tax amount of the distribution.
As you know, a contribution to a traditional IRA typically provides a deduction for the taxpayer while a contribution to a Roth IRA is after-tax. Therefore, the contribution amount in full will be the starting point for the Traditional IRA table. However, since a Roth IRA contribution is taxed, the net of tax amount of the contribution will be the starting point for the Roth IRA table.
Check figure: If you have prepared the worksheet correctly, the net of tax distribution amount will be the same for the traditional and Roth IRA if the tax rate on contribution and the tax rate on distribution are the same.
Assignment:
This assignment counts as a quiz. There are three parts to this assignment.
The working Excel model. I will test the model. The properly working model and graph will count as 80% of your quiz grade.
Your observation of what the model tells you about a Roth versus a Traditional IRA. Can you make a generalization about when it is best to use one over the other? Use your model to make this determination. This will count as 10% of your quiz grade.
Your graph showing the account balance at each year-end for the Roth and Traditional IRAs. This will count as 10% of your quiz grade
Upload a single Excel file with your observation about choosing between a Roth versus a Traditional IRA, the model worksheet, and the charts. Save all three as a single file and then upload via Canvas, prior to the deadline.
3 pages
The Department Of Homeland Security
According to Lansford & Pauly (2016), homeland security is a national security Umbrella term for America that has a mandat ...
The Department Of Homeland Security
According to Lansford & Pauly (2016), homeland security is a national security Umbrella term for America that has a mandate of ensuring that the ...
4 pages
Financial Ratios Analysis
Attached above are the financial statements for Smith Company, Inc. Use the financial statements to calculate the attached ...
Financial Ratios Analysis
Attached above are the financial statements for Smith Company, Inc. Use the financial statements to calculate the attached ratios. Write a couple of ...
Continuing Payroll Project: Wayland Custom Woodworking
Continuing Payroll Project: Wayland Custom WoodworkingWayland Custom Woodworking is a firm that manufactures custom cabine ...
Continuing Payroll Project: Wayland Custom Woodworking
Continuing Payroll Project: Wayland Custom WoodworkingWayland Custom Woodworking is a firm that manufactures custom cabinets and woodwork for business and residential customers. Students will have the opportunity to establish payroll records and to complete a month of payroll information for Wayland. Wayland Custom Woodworking is located at 1716 Nichol Street, Logan, Utah, 84321, phone number 435-555-9877. The owner is Mark Wayland. Wayland’s EIN is 91-7444533, and the Utah Employer Account Number is 999-9290-1. Wayland has determined it will pay their employees on a semimonthly basis. Federal income tax should be computed using the percentage method.
Answer the Below Question_Managing Inventory
(100 points.For problems involving the Normal Distribution you can use either Excel functions or the Normal tables provide ...
Answer the Below Question_Managing Inventory
(100 points.For problems involving the Normal Distribution you can use either Excel functions or the Normal tables provided at the end of the word document attachment.) Question 1 (8 pts) In fiscal year 2012, Apple Inc. (NASDAQ: AAPL) reported a cost of goods sold of $87,846 million and inventory valued at $2,583 million. a.What are Apple’s annual inventory turnovers? (4 pts) b.On average, how many days of inventory did Apple maintain to generate its sales in 2012? (4 pts) Question 2 (20 pts) The Bridgeport City Police need assistance in determining the number of additional police officers needed to cover daily absences due to injuries, sickness, vacations, and personal leave.Records indicate that the daily demand for additional police officers is normally distributed with a mean of 50 officers and a standard deviation of 10 officers.The cost of an additional police officer is based on the average pay rate of $150 per day.If the daily demand for police officers exceeds the number of additional officers available, the excess demand will be covered by overtime at the pay rate of $240 per day for each overtime officer. a.If the number of additional police officers available is greater than demand, the additional officers will have to be paid anyway.If the number of officers is less than demand, overtime will have to used and paid for.What are Cu and Co in this instance? (5 pts) b.On a typical day, what is the probability that overtime will be necessary?(5 pts) c.On a typical day, what is the probability that there will be excess additional police officers? (5 pts) d.What is the optimal daily number of additional officers that should be hired? (5 pts) Question 3 (24 pts). A retail outlet sells holiday decorations for $10 per bag.The cost of the product is $8 per bag.Any units not sold during the selling season can be sold for $5 a bag at the end of the season.Assume that demand for these decorations is normally distributed with a mean of 500 and standard deviation of 100 bags. a. What is the recommended order quantity? (5 pts) b. What is the probability that at least some customers will ask to purchase the product after the outlet is sold out? (5 pts) c. Suppose at the end of the selling season, the decorations have no value and have to be disposed of at a cost of $0.10 per bag.Now what is the optimal order quantity? (4 pts) d. To keep customers happy and coming back, the owner of the store feels that stock-outs should be avoided.What is the your recommended order quantity if the owner is willing to tolerate only a 0.15 probability of a stock-out? (5 pts) e.Using your answer to part (d) what is the goodwill cost you are assigning to a stock-out? (5 pts) Question 4 (24 pts) Ray's Satellite Emporium wishes to determine the best order size for its best-selling satellite dish.Ray has estimated thatweekly demand for this model to be 25 units.His cost to carry one unit is $50 per year and the cost of placing an order with his supplier is $25.He's open 52 weeks a year. If Ray were to use the EOQ method, a. How many dishes should Ray order each time he places an order? b. What isthe number of times Ray will order this dish each year? c. How many of this dish will he have on average in inventory? d. What is the time between one order and the next? e. What is the annual cost of using the EOQ model for this dish? f.Ray currently orders in quantities of 50 dishes per order.How much would he save or lose by switching to the EOQ? (4 pts each) Question 5 (24 pts) Ray's Satellite Emporium wishes to determine the best order size for its best-selling satellite dish.Ray has estimated that weekly demand for this model to be 25 units with a standard deviation of 5 units.His cost to carry one unit is $50 per year and the cost of placing an order with his supplier is $25.He's open 52 weeks a year.Assume weekly demand is normally distributed. (4 pts each) What is Ray’s economic order quantity in this situation? (Hint: Use average annual demand in EOQ formula)The lead-time for ordering from this supplier is 3 weeks.What are the mean and standard deviation of demand during lead time?Ray desires an in-stock service rate of 95%.How many units should Ray have on-hand at the time he places an order?How many units of safety stock will he carry?If Ray increases his in-stock service rate to 99% how many units of safety stock will have to carry?Ray is able to negotiate a lead-time of 2 weeks with the supplier.Now what safety stock will he have to carry with 95% and 99% in-stock service levels?Suppose Ray is able to reduce the standard deviation of demand (through a combination of lowered prices and loyalty schemes) to 3 units.How will this impact his safety stock assuming lead time of 3 weeks with a service level of 95%?
Similar Content
Colorado Technical University Statistical Terminology Decision Making Presentation
ScenarioBig data is everywhere, and various businesses around the world are driven by big data. While some businesses rely...
Jack Carter decided to take his first long vacation in years and go to Mexico, Case Question help
Jack Carter decided to take his first long vacation in years and go to Mexico for a month a few years ago. What he found s...
role of the derivatives in the in the Great Recession.
*Your own opinion of the role of the derivatives in the in the Great Recession. Five
pages, double space. Intro, body and...
Sales and Marketing Plan
Resource: The Analytic Hospitality Executive, Ch. 7Read the Case Study: Meetings and Events Revenue Management, Kate Keisl...
University of California Davis Primary Responsibilities Discussion Questions
1. What are your two primary responsibilities when editing or revising the work of another writer?2. Should you ever use e...
HRM 5360 Nova Southeastern University W8 Job Experiences Discussion
Question 1: In your experience (both from your own organization and your observation on other organizations), please ident...
Spreadsheet Decision Modeling.edited 1
Decision-making happens to be the exercise of making alternatives by determining a decision, gathering information, and as...
acc_202_week_2_assignment_1_ch.12_...
acc_202_week_2_assignment_1_ch.12_......
Training And Development
Training and development of the employees to improve their work efficiency and performance in the context of management re...
Related Tags
Book Guides
The Elegant Universe
by Brian Greene
The Grapes of Wrath
by John Steinbeck
Crime and Punishment
by Fyodor Dostoyevsky
Girl in Translation
by Jean Kwok
Death Of A Salesmen
by Arthur Miller
12 Rules for Life
by Jordan Peterson
The Lost Man
by Jane Harper
Their Eyes Were Watching God
by Zora Neale Hurston
The House of the Seven Gables
by Nathaniel Hawthorne
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
SDSU Roth IRA vs Traditional IRA Excel Sheet
PART II
You are a staff accountant at Anderson & Paul, a CPA firm located in downtown San Diego. A long-time cli ...
SDSU Roth IRA vs Traditional IRA Excel Sheet
PART II
You are a staff accountant at Anderson & Paul, a CPA firm located in downtown San Diego. A long-time client, Brady Patterson, has contacted you with a request. Brady is 52 years old and is currently in the 32% tax bracket. He is beginning to think about saving for retirement and has some questions. His employer does not offer a retirement plan so he is considering an IRA. However, he is confused about the differences between a Roth IRA and a Traditional IRA and needs your advice. He wants you to prepare an Excel spreadsheet that he can use to see the difference in a Traditional versus a Roth IRA.
Based on your discussion with Brady, the Excel model should cover a ten-year period. Brady would like to be able to change the following items in the model:
Year analysis begins
Amount of the IRA contribution (Note: only one contribution in this analysis – not one per year)
Tax rate at date of contribution (Note: assume the contribution is made on January 1 of the initial year)
Annual growth rate (Note: assume constant growth throughout the analysis period)
Tax rate at date of withdrawal (Note: assume the entire account balance is withdrawn at the end of the tenth year)
Prepare the model so that the above input variables automatically update the worksheet. This will allow Brady to test various assumptions and see the results of contributing to a Roth or a Traditional IRA.
The model should be based on a contribution only in the first year. Don’t build the model to have contributions every year.
The contribution should grow at the annual growth rate over a ten-year period. At the end of the ten years, the entire account balance is distributed to the account holder. The model should provide the net-of-tax amount the account holder will receive on distribution after the ten-year period and show the account balance each year.
Prepare one table showing the Roth IRA and one showing the Traditional IRA. Both tables and the input variable section should easily fit on a single page if set to print in landscape mode. Remember, a professional presentation includes proper titles and headings, is centered on the page when printed, and is a reasonable size on the page. Test the appearance of the worksheet by using the print preview function in Excel. Professional appearance is important so don’t overlook this part of the assignment.
The second page of your Excel model should be a graph showing the account balance at each year-end for the Roth and Traditional IRAs. The final year data point should be the net of tax amount of the distribution.
As you know, a contribution to a traditional IRA typically provides a deduction for the taxpayer while a contribution to a Roth IRA is after-tax. Therefore, the contribution amount in full will be the starting point for the Traditional IRA table. However, since a Roth IRA contribution is taxed, the net of tax amount of the contribution will be the starting point for the Roth IRA table.
Check figure: If you have prepared the worksheet correctly, the net of tax distribution amount will be the same for the traditional and Roth IRA if the tax rate on contribution and the tax rate on distribution are the same.
Assignment:
This assignment counts as a quiz. There are three parts to this assignment.
The working Excel model. I will test the model. The properly working model and graph will count as 80% of your quiz grade.
Your observation of what the model tells you about a Roth versus a Traditional IRA. Can you make a generalization about when it is best to use one over the other? Use your model to make this determination. This will count as 10% of your quiz grade.
Your graph showing the account balance at each year-end for the Roth and Traditional IRAs. This will count as 10% of your quiz grade
Upload a single Excel file with your observation about choosing between a Roth versus a Traditional IRA, the model worksheet, and the charts. Save all three as a single file and then upload via Canvas, prior to the deadline.
3 pages
The Department Of Homeland Security
According to Lansford & Pauly (2016), homeland security is a national security Umbrella term for America that has a mandat ...
The Department Of Homeland Security
According to Lansford & Pauly (2016), homeland security is a national security Umbrella term for America that has a mandate of ensuring that the ...
4 pages
Financial Ratios Analysis
Attached above are the financial statements for Smith Company, Inc. Use the financial statements to calculate the attached ...
Financial Ratios Analysis
Attached above are the financial statements for Smith Company, Inc. Use the financial statements to calculate the attached ratios. Write a couple of ...
Continuing Payroll Project: Wayland Custom Woodworking
Continuing Payroll Project: Wayland Custom WoodworkingWayland Custom Woodworking is a firm that manufactures custom cabine ...
Continuing Payroll Project: Wayland Custom Woodworking
Continuing Payroll Project: Wayland Custom WoodworkingWayland Custom Woodworking is a firm that manufactures custom cabinets and woodwork for business and residential customers. Students will have the opportunity to establish payroll records and to complete a month of payroll information for Wayland. Wayland Custom Woodworking is located at 1716 Nichol Street, Logan, Utah, 84321, phone number 435-555-9877. The owner is Mark Wayland. Wayland’s EIN is 91-7444533, and the Utah Employer Account Number is 999-9290-1. Wayland has determined it will pay their employees on a semimonthly basis. Federal income tax should be computed using the percentage method.
Answer the Below Question_Managing Inventory
(100 points.For problems involving the Normal Distribution you can use either Excel functions or the Normal tables provide ...
Answer the Below Question_Managing Inventory
(100 points.For problems involving the Normal Distribution you can use either Excel functions or the Normal tables provided at the end of the word document attachment.) Question 1 (8 pts) In fiscal year 2012, Apple Inc. (NASDAQ: AAPL) reported a cost of goods sold of $87,846 million and inventory valued at $2,583 million. a.What are Apple’s annual inventory turnovers? (4 pts) b.On average, how many days of inventory did Apple maintain to generate its sales in 2012? (4 pts) Question 2 (20 pts) The Bridgeport City Police need assistance in determining the number of additional police officers needed to cover daily absences due to injuries, sickness, vacations, and personal leave.Records indicate that the daily demand for additional police officers is normally distributed with a mean of 50 officers and a standard deviation of 10 officers.The cost of an additional police officer is based on the average pay rate of $150 per day.If the daily demand for police officers exceeds the number of additional officers available, the excess demand will be covered by overtime at the pay rate of $240 per day for each overtime officer. a.If the number of additional police officers available is greater than demand, the additional officers will have to be paid anyway.If the number of officers is less than demand, overtime will have to used and paid for.What are Cu and Co in this instance? (5 pts) b.On a typical day, what is the probability that overtime will be necessary?(5 pts) c.On a typical day, what is the probability that there will be excess additional police officers? (5 pts) d.What is the optimal daily number of additional officers that should be hired? (5 pts) Question 3 (24 pts). A retail outlet sells holiday decorations for $10 per bag.The cost of the product is $8 per bag.Any units not sold during the selling season can be sold for $5 a bag at the end of the season.Assume that demand for these decorations is normally distributed with a mean of 500 and standard deviation of 100 bags. a. What is the recommended order quantity? (5 pts) b. What is the probability that at least some customers will ask to purchase the product after the outlet is sold out? (5 pts) c. Suppose at the end of the selling season, the decorations have no value and have to be disposed of at a cost of $0.10 per bag.Now what is the optimal order quantity? (4 pts) d. To keep customers happy and coming back, the owner of the store feels that stock-outs should be avoided.What is the your recommended order quantity if the owner is willing to tolerate only a 0.15 probability of a stock-out? (5 pts) e.Using your answer to part (d) what is the goodwill cost you are assigning to a stock-out? (5 pts) Question 4 (24 pts) Ray's Satellite Emporium wishes to determine the best order size for its best-selling satellite dish.Ray has estimated thatweekly demand for this model to be 25 units.His cost to carry one unit is $50 per year and the cost of placing an order with his supplier is $25.He's open 52 weeks a year. If Ray were to use the EOQ method, a. How many dishes should Ray order each time he places an order? b. What isthe number of times Ray will order this dish each year? c. How many of this dish will he have on average in inventory? d. What is the time between one order and the next? e. What is the annual cost of using the EOQ model for this dish? f.Ray currently orders in quantities of 50 dishes per order.How much would he save or lose by switching to the EOQ? (4 pts each) Question 5 (24 pts) Ray's Satellite Emporium wishes to determine the best order size for its best-selling satellite dish.Ray has estimated that weekly demand for this model to be 25 units with a standard deviation of 5 units.His cost to carry one unit is $50 per year and the cost of placing an order with his supplier is $25.He's open 52 weeks a year.Assume weekly demand is normally distributed. (4 pts each) What is Ray’s economic order quantity in this situation? (Hint: Use average annual demand in EOQ formula)The lead-time for ordering from this supplier is 3 weeks.What are the mean and standard deviation of demand during lead time?Ray desires an in-stock service rate of 95%.How many units should Ray have on-hand at the time he places an order?How many units of safety stock will he carry?If Ray increases his in-stock service rate to 99% how many units of safety stock will have to carry?Ray is able to negotiate a lead-time of 2 weeks with the supplier.Now what safety stock will he have to carry with 95% and 99% in-stock service levels?Suppose Ray is able to reduce the standard deviation of demand (through a combination of lowered prices and loyalty schemes) to 3 units.How will this impact his safety stock assuming lead time of 3 weeks with a service level of 95%?
Earn money selling
your Study Documents
