Question

In: Finance

ront Page Video Games Corporation has forecasted the following monthly sales: January $108,000 July $53,000 February...

ront Page Video Games Corporation has forecasted the following monthly sales: January $108,000 July $53,000 February 101,000 August 53,000 March 33,000 September 63,000 April 33,000 October 93,000 May 28,000 November 113,000 June 43,000 December 131,000 Total sales = $852,000 The firm sells its Last Spike video game for $5 per unit, and the cost to produce the game is $2 per unit. 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 33,000 units. (Note: To do part a, you should work in terms of units of production and units of sales.) Front Page Video Games Corporation Production and inventory schedule in units Beginning inventory + Production – Sales = Ending inventory January 33,000 + – = February + – = March + – = April + – = May + – = June + – = July + – = August + – = September + – = October + – = November + – = December + – = b. Prepare a monthly schedule of cash receipts. Sales in the December before the planning year were $100,000. Work part b using dollars. Front Page Video Games Corporation January February March April May June Sales $ $ $ $ $ $ Cash sales Prior month’s sales Total cash receipts $ $ $ $ $ $ Front Page Video Games Corporation July August September October November December Sales $ $ $ $ $ $ Cash sales Prior month’s sales Total cash receipts $ $ $ $ $ $ c. Determine 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 $53,000 per month. Front Page Video Games Corporation Constant production January February March April May June Production cost $ $ $ $ $ $ Other cash payments Total cash payments $ $ $ $ $ $ Front Page Video Games Corporation Constant production July August September October November December Production cost $ $ $ $ $ $ Other cash payments Total cash payments $ $ $ $ $ $ d. Prepare a monthly cash budget for January through December. The beginning cash balance is $5,000, and that is also the minimum desired. (Do not leave any empty spaces; input a 0 wherever it is required. Negative answers and amounts to be deducted should be indicated by a minus sign.) Front Page Video Games Corporation January February March April May June Net cash flow $ $ $ $ $ $ Beginning cash Cumulative cash balance $ $ $ $ $ $ Monthly loan or (repayment) Cumulative loan Ending cash balance $ $ $ $ $ $ Front Page Video Games Corporation July August September October November December Net cash flow $ $ $ $ $ $ Beginning cash Cumulative cash balance $ $ $ $ $ $ Monthly loan or (repayment) Cumulative loan Ending cash balance $ $ $ $ $ $

Solutions

Expert Solution

Answer a.

Answer b.

Answer c.

Answer d.


Related Solutions

Front Page Video Games Corporation has forecasted the following monthly sales:   January $98,000   July $43,000     February...
Front Page Video Games Corporation has forecasted the following monthly sales:   January $98,000   July $43,000     February 91,000   August 43,000   March 23,000   September 53,000   April 23,000   October 83,000   May 18,000   November 103,000   June 33,000   December 121,000   Total sales = $732,000 The firm sells its Last Spike video game for $5 per unit, and the cost to produce the game is $2 per unit. A level production policy is followed. Each month's production is equal to annual sales (in units) divided by...
Front Page Video Games Corporation has forecasted the following monthly sales:   January $100,000   July $45,000     February...
Front Page Video Games Corporation has forecasted the following monthly sales:   January $100,000   July $45,000     February 93,000   August 45,000   March 25,000   September 55,000   April 25,000   October 85,000   May 20,000   November 105,000   June 35,000   December 123,000   Total sales = $756,000 The firm sells its Last Spike video game for $5 per unit, and the cost to produce the game is $2 per unit. A level production policy is followed. Each month's production is equal to annual sales (in units) divided by...
Bombs Away Video Games Corporation has forecasted the following monthly sales:    January $ 102,000 July...
Bombs Away Video Games Corporation has forecasted the following monthly sales:    January $ 102,000 July $ 47,000 February 95,000 August 47,000 March 27,000 September 57,000 April 27,000 October 87,000 May 22,000 November 107,000 June 37,000 December 125,000 Total annual sales = $780,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...
Bombs Away Video Games Corporation has forecasted the following monthly sales:    January $ 116,000 July...
Bombs Away Video Games Corporation has forecasted the following monthly sales:    January $ 116,000 July $ 61,000 February 109,000 August 61,000 March 41,000 September 71,000 April 41,000 October 101,000 May 36,000 November 121,000 June 51,000 December 139,000 Total annual sales = $948,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...
Bombs Away Video Games Corporation has forecasted the following monthly sales:    January $ 112,000 July...
Bombs Away Video Games Corporation has forecasted the following monthly sales:    January $ 112,000 July $ 57,000 February 105,000 August 57,000 March 37,000 September 67,000 April 37,000 October 97,000 May 32,000 November 117,000 June 47,000 December 135,000 Total annual sales = $900,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...
Bombs Away Video Games Corporation has forecasted the following monthly sales:    January $ 103,000 July...
Bombs Away Video Games Corporation has forecasted the following monthly sales:    January $ 103,000 July $ 48,000 February 96,000 August 48,000 March 28,000 September 58,000 April 28,000 October 88,000 May 23,000 November 108,000 June 38,000 December 126,000 Total annual sales = $792,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...
Bombs Away Video Games Corporation has forecasted the following monthly sales: January $ 89,000 July $...
Bombs Away Video Games Corporation has forecasted the following monthly sales: January $ 89,000 July $ 41,000 February 96,000 August 41,000 March 21,000 September 51,000 April 21,000 October 81,000 May 16,000 November 101,000 June 31,000 December 119,000 Total annual sales = $708,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...
Bombs Away Video Games Corporation has forecasted the following monthly sales:   January $ 120,000   July $...
Bombs Away Video Games Corporation has forecasted the following monthly sales:   January $ 120,000   July $ 65000   February 113000   August 65000   March 45000   September 75000   April 45000   October 105000   May 40000   November 125000   June 55000   December 143000 Total annual sales = $996,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...
Bombs Away Video Games Corporation has forecasted the following monthly sales: January $ 111,000 July $...
Bombs Away Video Games Corporation has forecasted the following monthly sales: January $ 111,000 July $ 56,000 February 104,000 August 56,000 March 36,000 September 66,000 April 36,000 October 96,000 May 31,000 November 116,000 June 46,000 December 134,000 Total annual sales = $888,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...
Bombs Away Video Games Corporation has forecasted the following monthly sales:    January $ 116,000 July...
Bombs Away Video Games Corporation has forecasted the following monthly sales:    January $ 116,000 July $ 61,000 February 109,000 August 61,000 March 41,000 September 71,000 April 41,000 October 101,000 May 36,000 November 121,000 June 51,000 December 139,000 Total annual sales = $948,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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT