Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Back Page Video Games Corporation has forecasted total sales for noxt financial year as $2,256,000 and the the following monttly sales are prupected for Jarniny
Back Page Video Games Corporation has forecasted total sales for noxt financial year as $2,256,000 and the the following monttly sales are prupected for Jarniny to June: The firm selts its popular Last Spike video garme for 55 per unit, and the cost to produce the garne is 5. per unit. A kevel production policy is followed. Each morth's production is equal to total arnual salks (in units) devided by 12 Of each month's sales, 30 percent are for cash and 70 percent are on account. All accounts receivalde are collected in the month after the sale is made a. Construct a monttly production and irventory schedule in units. Begining irventory in Jonuary is 25,000 units. (Note. To do part a, you should work in lorms of units of production and units of sales, ) b. Prepare a monthly schedule of cash receipts. Sales in the December before the planning year were $120,000. Work part b using dollars. c Determine a cash payments schedule for January through June. The production costs of \$2 per unit 40 percent of the production cost is paid for in the month in which they occur and 60 percent of the production cost is paid in the following month 36,000 units were producnd in December of the prior year. Odver cash payments, besides those for production costs, are $30,000 per month Dwidends of $40,000 is due for payment in March and June d. Prepare a monthly cash budget for January through June. The beginning cash balance is 55,000 , and that is also the minimum desired Use the key facts bekw to enter formulas to solve the requirements of the problim. Key facts: Solling pice per unit Cost to produce Percort of sales on cash basis 55 52 30% a. Construct a monthly production and irventory schedule in units. Begirning irventory in January is 25,000 units. (Note To do part a, you should work in terms of units of production and units of sales) 6. Prepare a monthly schedule of cash rocolpts. Sales in the December belore the planning yoar were \$120,000. Note. Work this part using dollars. c. Dotermine a cash payments schedule for January through June. The production costs of \$2 per unit 40 percent of the production cost is paid for in the month in which they occur and 60 percert of the production cost is paid in the following month. 35,000 units were produced in December of the prior year Ocher cash payments besides those for production costs, are $30,000 per month. Dividends of $40,000 is due for payment in Warch and June 5170,600 Nole Work thio pat ering doflert Chahn 30% Cich nakes roW, prior morith's sales Iotal canch recoiptes 52 per urit 40 percert of the prodocfion cait b paid for h the monith in which they ocour and 60 percent of the production coul ho puid in the following month. 35,000 units were produced in Docember of the prior yoar. Oocher cash payments, benides ithene fror production costs, are 530,000 per montt. Divibonds of 540.000 is doe for prymont in March and June A Prepare a monttly cash budget for January theough June. The begirning cash balance is $5,060. and that is also the minimum desited
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