Spelling Company has the following sales projection (in units) for the next six months: Feb: 7500...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Spelling Company has the following sales projection (in units) for the next six months: Feb: 7500 Mar: 8500 Apr: 6500 May: 10000 Jun: 8000 Jul: 5500 Each unit sells for $20. Spelling has prepared the following sales budget for the quarter of April, May and June: Sales Budget Sales in units Selling price per unit Sales revenue April 6500 May 10000 June 8000 Total 24500 x $20 $130000 x $20 $200000 x $20 $160000 $490000 Spelling's cost of goods sold is 40% of its sales revenue. The company has a policy that it keeps 30% of next months budgeted cost of goods sold as ending inventory. The company had exactly the budgeted amount of inventory on hand at April 1. Prepare a purchases budget on paper or, PREFERABLY, in Excel for the quarter of April, May and June. (If you build your schedule using formulas in excel, multiple attempts will be much faster.) What is the cost of inventory at April 1 (Beginning inventory) Hint: This is the same as budgeted inventory at 3/31. According to the rule that is April COGS x 30%. What is the budgeted cost of purchases in May? What is the desired cost of inventory at the end of the quarter? Hint: According to the rule that is July COGS x 30%. CHECK ANSWER Spelling Company has the following sales projection (in units) for the next six months: Feb: 7500 Mar: 8500 Apr: 6500 May: 10000 Jun: 8000 Jul: 5500 Each unit sells for $20. Spelling has prepared the following sales budget for the quarter of April, May and June: Sales Budget Sales in units Selling price per unit Sales revenue April 6500 May 10000 June 8000 Total 24500 x $20 $130000 x $20 $200000 x $20 $160000 $490000 Spelling's cost of goods sold is 40% of its sales revenue. The company has a policy that it keeps 30% of next months budgeted cost of goods sold as ending inventory. The company had exactly the budgeted amount of inventory on hand at April 1. Prepare a purchases budget on paper or, PREFERABLY, in Excel for the quarter of April, May and June. (If you build your schedule using formulas in excel, multiple attempts will be much faster.) What is the cost of inventory at April 1 (Beginning inventory) Hint: This is the same as budgeted inventory at 3/31. According to the rule that is April COGS x 30%. What is the budgeted cost of purchases in May? What is the desired cost of inventory at the end of the quarter? Hint: According to the rule that is July COGS x 30%. CHECK ANSWER
Expert Answer:
Answer rating: 100% (QA)
To prepare the purchases budget for the quarter of April May and June we need to calculate the cost ... View the full answer
Posted Date:
Students also viewed these accounting questions
-
1.Marilyn bought a big screen TV and paid $300 down payment with the balance to be paid by 12 monthly payments of $98 including interest at 5% compounded quarterly. What was the purchase price of the...
-
Patel Instruments Company has the following sales budget for the first three months of the current year: Month Sales Revenue January $900,000 February 225,000 March 660,000 Historically, the...
-
Delmott sells a snowboard, Xpert that is popular with snowboard enthusiasts. Below is information relating to Delmotts purchases of Xpert snowboards during September. During the same month, 102 Xpert...
-
J. M. Keynes wrote, "If the Treasury were to fill old bottles with banknotes, bury them in disused coal mines, and leave it to private enterprise to dig the notes up again, there need be no more...
-
Show the FP tree that would be made for the data from Exercise 28.14.
-
Assume that you believe purchasing power parity (PPP) exists. You expect that inflation in Canada during the next year will be 3 percent and inflation in the United States will be 8 percent. Today...
-
Specialty Appliances and More, Inc. ( SAM) has a three- year warranty on their solar refrigerators for defects. Warranty costs are estimated at 2% of sales in year one ( the year of the sale), and 5%...
-
7. You just won a lottery and have two payout options. You can either take a $500,000 prize today, or you can choose to wait five years and receive $900,000. If you choose to wait, what will your...
-
Who' does demand labor from physicians? Explain why. Now, think solely about the healthcare market in which you work or that is of interest to you and concentrate solely on the labor market. Think...
-
What are the top four benefits of being a digital business? Why are these more important than other benefits ?
-
What are the different ways digital technology advancements disrupt the tax function?
-
What are the different ways digital technology advancements disrupt the financial accounting function?
-
What are the different ways digital technology advancements disrupt the management accounting function?
-
What are the different ways digital technology advancements disrupt the accounting value proposition?
-
Plank Co. uses the conventional retail inventory method. The following information is available for the current year. Cost Retail Beginning inventory $ 312,000 $488,000 Purchases Freight-in Net...
-
A woman at a point A on the shore of a circular lake with radius 2 mi wants to arrive at the point C diametrically opposite on the other side of the lake in the shortest possible A time. She can walk...
-
Time value is the anticipation of intrinsic value being stronger than it is now. However, intrinsic value can drop. Why then can time value not be negative?
-
In concrete terms, what does the difficulty in valuing an option boil down to?
-
Show how the purchase of an option and the sale of another option can protect you against the risk of a drop in the value of the underlying share, without costing you anything if you give up the...
Study smarter with the SolutionInn App