College Finance 1 - Financial Forecasting

2 InnerVision Limited anticipates total sales of $360,000 from July through October. Materials will represent 60 percent of sales and because of level production, material purchases will be equal for each month during these four months Materials are paid for one month after the month purchased. Materials purchased in June were $32,000 (half of $64,000 in sales). Labour costs for each of the four months are slightly different due to a provision in the labour contract in which bonuses are paid in August and October. Fixed overhead is $18,000 monthly. The labour figures are July August September 22,000 October $22,000 25,000 27,000 Prepare a schedule of cash payments for July through October InnerVision, Inc. Cash Payment Schedule June August September October Purchases Payment to material purchases Labour Fixed overhead Total cash payments