Question

In: Accounting

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 12.

Of each month's sales, 40 percent are for cash and 60 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 23,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 23,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 $43,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


Related Solutions

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...
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...
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