Reference no: EM13951904
Javier Andreas is in the process of developing a spreadsheet to budget annual sales and purchases of inventory for his company, The Backyard Place, a retail store that sells lighting, furniture, and other amenities for the backyard. In 2011,sales were as follows:
Inventory at the end of 2011 is $15,000.
Required:
Help Javier build a spreadsheet that will allow him to examine the impact on purchases of inventory of the following three items:
1. Sales growth from 2011 to 2012. Javier believes that quarterly sales will grow by 10 percent in 2012 compared to the corresponding quarter in 2011, and sales in the first quarter of 2013 will be 10 percent higher than in 2012. However, he would also like to explore the effect on purchases of alternative growth rates. Thus, your spreadsheet must allow you to change this value and observe the effect on all other values.
2. Inventory on hand at the end of each quarter. Javier is tentatively planning to have ending inventory equal to 20 percent of the amount needed to meet the next quarter's sales. He would also like to explore the effect on purchases of alternative rates. Thus, your spread-sheet must allow you to change this value and observe the effect on purchases.
3. Cost of goods sold. Javier estimates that cost of goods sold as a percent of sales will be 30 percent. He would also like to explore the effect on purchases of different rates. Thus, your spreadsheet must allow you to change this value. After you have developed your spreadsheet, calculate purchases in the first quarter through the fourth quarter of 2012 for the following combinations:
Combination 1 Sales growth of 10 percent, ending inventory of 22 percent, cost of goods sold of 33 percent
Combination 2 Sales growth of 15 percent, ending inventory of 24 percent, cost of goods sold of 28 percent
Combination 3 Sales growth of 9 percent, ending inventory of 34 percent, cost of goods sold of 40 percent
|
Find the magnitude and the direction of the net force
: Suppose that the coefficients of static and kinetic friction have values such that µs = 1.4 µk for a crate in contact with a cement floor. Does this mean that the magnitude of the static frictional force acting on the crate at rest would always be..
|
|
Which of the above is an example of functional cohesion
: Which of the above is an example of procedural cohesion?
|
|
Health insurance portability and accountability act
: The Health Insurance Portability and Accountability Act (HIPAA) was enacted in 1996 to protect health insurance coverage, reduce healthcare fraud, and mandate industry standards for the protection of health information and electronic management of..
|
|
Break-even point in dollars for proposal
: What is the break-even point in dollars for proposal A if you add $10,000 installation to the fixed cost? What is the break-even point in dollars for proposal B if you add $10,000 installation to the fixed cost?
|
|
Calculate purchases in the first quarter through
: Calculate purchases in the first quarter through the fourth quarter of 2012 for the following combinations:
|
|
Maintain a constant growth rate in dividends
: Apocalyptica Corporation is expected to pay the following dividends over the next four years: $5.90, $16.90, $21.90, and $3.70. Afterwards, the company pledges to maintain a constant 6.00 percent growth rate in dividends, forever.
|
|
Develop five additional questions
: As part of this report, develop five additional questions that you believe should be asked by the principal and HR manager when selecting a new employee. Using three external sources, provide supporting rationale to support the five additional que..
|
|
Operating assets is considering the purchase of a machine
: A company with $825,000 in operating assets is considering the purchase of a machine that costs $87,000 and which is expected to reduce operating costs by $19,000 each year. These reductions in cost occur evenly throughout the year. The payback perio..
|
|
Concept of the third degree price discrimination
: Answer to the following question: i) Explain the concept of the third degree price discrimination. Who gains and who loses and how?
|