Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Back Page Video Games Corporation has forecasted total sales for next financial year as $2,600,000 and the the following monthly sales are projected for January
Back Page Video Games Corporation has forecasted total sales for next financial year as $2,600,000 and the the following monthly sales are projected for January to June: The firm sells its popular Last Spike video game for 58 per unit, and the cost to produce the game is 54 per unit. A level production policy is followed. Each month's production is equal to total annual sales (in units) divided by 12. Of each month's sales, 30 percent are for cash and 70 percent are on account. All accounts receivable are collected in the month after the sale is made. a. Construct a monthly production and inventory schedule in units. Beginning inventory in January is Instructions Of each month's sales, 30 percent are for cash and 70 percent are on account. All accounts receivable are collected in the month after the sale is made. a. Construct a monthly production and inventory schedule in units. Beginning inventory in January is 30,000 units. (Note: To do part a, you should work in terms 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 $150,000. Work part b using dollars. c. Determine a cash payments schedule for January through December. The production costs of $4 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. 35,000 units were produced in December of the prior year. Other cash payments, besides those for production costs, are $45,000 per month. Dividends of $50,000 is due for payment in March and June d. Prepare a monthly cash budget for January through June. The beginning cash balance is Use the key facts below to enter formulas to solve the requirements of the problem. Key facts: Selling price per unit Cost to produce Percent of sales on cash basis a. Construct a monthly production and inventory schedule in units. Beginning inventory in January is 30,000 units. (Note: To do part a, you should work in terms of units of production and units of sales. Round to zero decimal) $150,000. Work part b using dollars. c. Determine a cash payments schedule for January through December. The production costs of $4 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. 35,000 units were produced in December of the prior year. Other cash payments, besides those for production costs, are $45,000 per month. Dividends of $50,000 is due for payment in March and June d. Prepare a monthly cash budget for January through December. The beginning cash balance is $15,000, and that is also the minimum desired
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