20f5 (0o Anderson Foods produces specialty soup sold in jars. The projected sale
ID: 2576138 • Letter: 2
Question
20f5 (0o Anderson Foods produces specialty soup sold in jars. The projected sales in dollars and jars for each quarter of the upcoming year are as follows Total sales revenue $186,000 $212,000 $257,000 $194,000 Number of jars sold 1st quarter. 2nd quarter .. 3rd quarter. 4th quarter 154,500 183,000 211,500 164,500 PIOUuCuon Duuge For the Quarters in the Upcoming Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Unit sales Plus: Desired ending inventory Total needed Less: Beginning inventory Units to produce Enter any number in the edit fields and then continue to the next question.Explanation / Answer
Production Budget
Year 1
Year 2
Quarter
1
2
3
4
total
Q1
Unit sales
154500
183000
211500
164500
713500
226000
+desired ending inventory =30% of following quarter sales
54900
63450
49350
67800
235500
total needed
209400
246450
260850
232300
949000
less beginning inventory
46350
54900
63450
49350
214050
Units to produce
163050
191550
197400
182950
734950
Quarter 1 beginning inventory
154500*30%
46350
Production Budget
Year 1
Year 2
Quarter
1
2
3
4
total
Q1
Unit sales
154500
183000
211500
164500
713500
226000
+desired ending inventory =30% of following quarter sales
54900
63450
49350
67800
235500
total needed
209400
246450
260850
232300
949000
less beginning inventory
46350
54900
63450
49350
214050
Units to produce
163050
191550
197400
182950
734950
Quarter 1 beginning inventory
154500*30%
46350
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.