Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Front Page Video Games loves the work you did for them on their Last Spike video game facility so now they want you to do
Front Page Video Games loves the work you did for them on their Last Spike video game facility so now they want you to do an even more detailed analysis for a second manufacturing facility they are planning to run that will make a completely different game called First Spike. They want you to develop forecasts for 2022 using the following information. Forecast year Month Sales ($) Other Cash Payments Ending Cash Ending Inventory Units Units Produced 2021 November $ 14,000 2,083 December 28,000 $ 8,333 4,167 5,000 2022 January 280,000 $ 53,200 February 90,000 61,600 March 27,500 64,400 April 308,000 56,000 May 336,000 75,600 June 280,000 72,800 July 364,000 53,200 August 308,000 56,000 September 308,000 56,000 October 392,000 58,800 November 364,000 61,600 December 308,000 56,000 2023 January 280,000 61,600 Sale price per unit is: $ 23 Cost per unit is: 15 Cash flows for unit costs in any month is the cost per unit times the units produced in the prior month because all unit costs are purchased on account (Accounts Payable) in the month produced and paid in full the following month. Similarly, Other Cash Payments in a month are payments regarding other expenses purchased on account in the prior month. Front Page wants to keep its facility running with a level production policy but they realize this might not be entirely realistic. To save capital investment they are purchasing used equipment that will require extensive repairs and maintenance twice a year. This means that in June and December they will only be able to produce a maximum number of units of: 5,000 units First Spike sales are expected to be a mix of direct online cash sales and various distributors. The distributor's sales will all be on account. Cash receipts from distributor sales are expected to be received across the two months following the sale. Front Page expects cash receipts to be approximately: Cash sales 30% A/R from 1 month prior 65% A/R from 2 months prior 35% MARKS 20 a. Construct a monthly production and inventory schedule in units. Note: To do part a, you should work in terms of units of production and units of sales. 20 b. Prepare a monthly schedule of cash receipts. 20 c. Prepare a monthly schedule of cash payments.
Front Page Video Games loves the work you did for them on their Last Spike video game facility so now they want you to | ||||||||
do an even more detailed analysis for a second manufacturing facility they are planning to run that will make a completely different | ||||||||
game called First Spike. | ||||||||
They want you to develop forecasts for 2022 using the following information. | ||||||||
Forecast year | Month | Sales ($) | Other Cash Payments | Ending Cash | Ending Inventory Units | Units Produced | ||
2021 | November | $ 14,000 | 2,083 | |||||
December | 28,000 | $ 8,333 | 4,167 | 5,000 | ||||
2022 | January | 280,000 | $ 53,200 | |||||
February | 90,000 | 61,600 | ||||||
March | 27,500 | 64,400 | ||||||
April | 308,000 | 56,000 | ||||||
May | 336,000 | 75,600 | ||||||
June | 280,000 | 72,800 | ||||||
July | 364,000 | 53,200 | ||||||
August | 308,000 | 56,000 | ||||||
September | 308,000 | 56,000 | ||||||
October | 392,000 | 58,800 | ||||||
November | 364,000 | 61,600 | ||||||
December | 308,000 | 56,000 | ||||||
2023 | January | 280,000 | 61,600 | |||||
Sale price per unit is: | $ 23 | |||||||
Cost per unit is: | 15 | |||||||
Cash flows for unit costs in any month is the cost per unit times the units produced in the prior month because | ||||||||
all unit costs are purchased on account (Accounts Payable) in the month produced and paid in full the following month. | ||||||||
Similarly, Other Cash Payments in a month are payments regarding other expenses purchased on account in the prior month. | ||||||||
Front Page wants to keep its facility running with a level production policy but they realize this might not be entirely realistic. | ||||||||
To save capital investment they are purchasing used equipment that will require extensive repairs and | ||||||||
maintenance twice a year. This means that in June and December they will only be able to produce a maximum | ||||||||
number of units of: | 5,000 | units | ||||||
First Spike sales are expected to be a mix of direct online cash sales and various distributors. The distributor's sales will | ||||||||
all be on account. Cash receipts from distributor sales are expected to be received across the two months following the sale. | ||||||||
Front Page expects cash receipts to be approximately: | ||||||||
Cash sales | 30% | |||||||
A/R from 1 month prior | 65% | |||||||
A/R from 2 months prior | 35% | |||||||
MARKS | ||||||||
20 | a. Construct a monthly production and inventory schedule in units. | |||||||
Note: To do part a, you should work in terms of units of production and units of sales. | ||||||||
20 | b. Prepare a monthly schedule of cash receipts. | |||||||
20 | c. Prepare a monthly schedule of cash payments. | |||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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