Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance For IT Decision Makers

Authors: Michael Blackstaff

3rd Edition

1780171226, 978-1780171227

More Books

Students also viewed these Finance questions