Fab and Fast Ltd buys and sells motor vehicle accessories. The firm’s estimated sales and expenses for the first 4 months of 2020 are shown below.

Actual sales for December 2019 were $900 000 and actual expenses were $258 000.
All sales are on credit, and the firm estimates that 40% of the accounts receivable will be collected in the month of sale with the other 60% collected the following month. The average selling price for the products sold is $300. The cash balance as at 1 January 2020 is expected to be $70 000. The firm pays for 30% of its purchases in the month of the purchase and the balance is paid in the following month. Average gross profit margin is 40%. The firm plans to continue maintaining an end-of-month inventory equal to 10% of the next month’s projected cost of sales. Depreciation amounting to $24 000 per month and wages of $104 000 are included in the monthly expenses of $258 000. Other expenses are paid during the month they are incurred.
Required

(a) Prepare a monthly schedule of expected cash receipts for the first quarter of 2020.

(b) Prepare a monthly purchases budget for the first quarter of 2020.

(c) Prepare a monthly schedule of expected cash payments for the first quarter of 2020.

(d) Prepare a monthly cash budget for the first quarter of 2020.

(e) Prepare a monthly budgeted income statement for the first quarter of 2020.

(f) Calculate the difference between the expected increase in cash and the expected profit or loss for the first quarter. Explain why the two amounts are different.

Transcribed Image Text:

January February March April Sales $1 000 000 1 300 000 900 000 Expenses $258 000 258 000 258 000 800 000 258 000