Question
Mulligan Fruits Corporation wholesales peaches and oranges. Kimberly Priest is working with the companys accountant to prepare next years budget. Ms. Priest estimates that sales
Mulligan Fruits Corporation wholesales peaches and oranges. Kimberly Priest is working with the companys accountant to prepare next years budget. Ms. Priest 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 | $ | 221,000 | $ | 241,000 | $ | 301,000 | $ | 241,000 | $ | 1,004,000 | |||||
Oranges | 417,000 | 467,000 | 587,000 | 397,000 | 1,868,000 | ||||||||||
Total | $ | 638,000 | $ | 708,000 | $ | 888,000 | $ | 638,000 | $ | 2,872,000 | |||||
Based on the companys past experience, cost of goods sold is usually 65 percent of sales revenue. Company policy is to keep 10 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 $660,000, prepare the companys budgeted annual income statement. |
c. | Ms. Priest estimates next years ending inventory will be $34,900 for peaches and $56,100 for oranges. Prepare the companys inventory purchases budgets for the next year, showing quarterly figures by product. (Round your answers to the nearest whole dollar amount.) |
Inventory purchases budget for peaches: |
Inventory purchases budget for oranges: |
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