Crane Manufacturing, located in France, has projected sales in units for four months of operations as follows:

January		20,000
February		25,000
March		27,000
April		30,000

The product sells for 12 per unit. 20% of the customers are expected to pay in the month of sale and take a 3% discount; 75% are expected to pay in the month following sale. The remaining 5% will never pay.

It takes 2 kilograms of materials to produce a unit of product. The materials cost 0.60 per kilogram. In January, no raw materials are in beginning inventories, but managers want to end each month with enough materials for 20% of the next months production. The firm pays for 60% of its materials purchases in the month of purchase and 40% in the following month.

It takes 0.5 hour of labour to produce each unit. Labour is paid 12 per hour and is paid in the same month as worked. Overhead is estimated to be 2 per unit plus 20,000 per month (including amortization of 12,000). Overhead costs are paid as they are incurred.

Crane will begin January with no finished goods or work-in-process inventory. The managers want to end each month with 25% of the following months sales in finished goods inventory. They will end each month with no work in process.

Prepare a cash budget listing cash receipts and disbursements for February. The firm will begin February with a cash balance of 80,000.

fyi There Are 3 bars that need to be filled behind the options

Please only complete if you know what youre doing

80,000. (Round all entries to whole amounts, e.g. 5,275. Do not enter currency symbols in your answer.) Crane Manufacturing Cash Budget Ending balance, February 28 Subtotal February receipts Beginning balance, February 1 Total disbursements Overhead Raw materials Disbursements Labour