Question

Bombs Away Video Games Corporation has forecasted the following monthly sales:
  

January	$	114,000	July	$	59,000
February		107,000	August		59,000
March		39,000	September		69,000
April		39,000	October		99,000
May		34,000	November		119,000
June		49,000	December		137,000
Total annual sales = $924,000

Bombs Away Video Games sells the popular Strafe and Capture video game. It sells for $5 per unit and costs $2 per unit to produce. A level production policy is followed. Each month's production is equal to annual sales (in units) divided by 12.
Of each month's sales, 20 percent are for cash and 80 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 39,000 units.

	Beginning Inventory +	Production -	Sales =	Ending Inventory
Jan
Feb
Mar
April
May
June
July
Aug
Sep
OCt
Nov
Dec

b. Prepare a monthly schedule of cash receipts. Sales in December before the planning year are $100,000.
  

	Jan	Feb	March	April	may	june
Sales
Cash receipts
Cash sales
Prior month credit sales
Total cash receipts

	july	aug	sep	oct	nov	dec
sales
cash recepts
cash sales
prior months credit sales
total csh receipts

c. Prepare a cash payments schedule for January through December. The production costs of $2 per unit are paid for in the month in which they occur. Other cash payments, besides those for production costs, are $59,000 per month.
  

	jan	feb	march	april	may	june
production cost
other cash paymts
total cash paymets

	july	aug	sep	oct	nov	dec
production cost
other cash pyments
total cash pyments

d. Prepare a monthly cash budget for January through December using the cash receipts schedule from part b and the cash payments schedule from part c. The beginning cash balance is $5,000, which is also the minimum desired. (Negative amounts should be indicated by a minus sign.)
  

	jan	feb	march	april	may	june
beg. cash
net cash flow
cumulative csh balance
monthly loan (repaymemt)
ending cash balance
cumulative loan balance

	july	aug	sept	oct	nov	dec
beginn balance
net cash flow
cumulative cash balance
monthly loan (repayment)
ending cash balance
cumulative loan balance

Answer 1

Answer a.

Answer b.

Answer c.

Answer d.