Question
Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the companys accountant to prepare next years budget. Ms. Jasper estimates that sales
Jasper Fruits Corporation wholesales peaches and oranges. Barbara Jasper is working with the companys accountant to prepare next years budget. Ms. Jasper estimates that sales will increase 3 percent for peaches and 8 percent for oranges. The current years sales revenue data follow:
First Quarter | Second Quarter | Third Quarter | Fourth Quarter | Total | |||||||||||
Peaches | $ | 237,000 | $ | 257,000 | $ | 317,000 | $ | 257,000 | $ | 1,068,000 | |||||
Oranges | 400,000 | 450,000 | 570,000 | 380,000 | 1,800,000 | ||||||||||
Total | $ | 637,000 | $ | 707,000 | $ | 887,000 | $ | 637,000 | $ | 2,868,000 | |||||
Based on the companys past experience, cost of goods sold is usually 70 percent of sales revenue. Company policy is to keep 20 percent of the next periods estimated cost of goods sold as the current periods ending inventory. (Hint: Use the cost of goods sold for the first quarter to determine the beginning inventory for the first quarter.)
Required
a. Prepare the companys sales budget for the next year for each quarter by individual product.
b. If the selling and administrative expenses are estimated to be $680,000, prepare the companys budgeted annual income statement.
c. Ms.Jasper estimates next years ending inventory will be $35,900 for peaches and $57,400 for oranges. Prepare the companys inventory purchases budgets for the next year, showing quarterly figures by product.
Ms. Jasper estimates next years ending inventory will be 35,900 for peaches. Prepare the companys inventory purchases budgets for the next year, showing quarterly figures by product. (Round your final answers to nearest whole dollar.)
|
Ms. Jasper estimates next years ending inventory will be 57,400 for oranges. Prepare the companys inventory purchases budgets for the next year, showing quarterly figures by product. (Round your final answers to nearest whole dollar.)
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started