Reference no: EM132520713

Bags To Go manufactures suitcases with wheels which it sells to specialty retailers. One of their products, the Durawheel, is a medium sized suitcase made of plastic with metal wheels. The company is in the process of preparing its budget for the month ended December 31, 2019.

The following information was gathered to assist in the preparation of the budget:

Sales Projection:

December sales 1,000 suitcases

January sales 400 suitcases

February sales 500 suitcases

• The suitcases are expected to sell for $300 per unit. On November 30, 2019 Accounts Receivable equaled $96,000. The company expects to collect 60 percent of sales in the month of sale and the remainder in the following month.

Production: The company would like to produce enough Durawheels to meet current month sales requirements plus have sufficient inventory on hand, at the end of each month, to meet 10 percent of next month's projected sales. On November 30, 2019 the company had 100 Durawheels in its finished goods inventory.

Direct Materials: Plastic: 2 kilograms at $10.00/kilogram are required to make one Durawheel.

Metal: .5 kilograms at $ 8.00/kilogram are required to make one Durawheel.

• The company would like to purchase enough direct material to meet current month production needs plus have 5 percent of next month's production needs in inventory at the end of the month. On November 30, 2013 there were 94 kilograms of plastic in inventory and 25 kilograms of metal in inventory.

• On November 30, 2013 Accounts Payable equaled $11,760 (includes both plastic and metal. The company expects to pay for 30 percent of its direct material purchases in the month of purchase and the remainder in the following month.

REQUIRED:

Question a. Make a production budget for the months of December and January.

Question b. make a direct material purchases budget for plastic for the month of December.

Question c. make a direct material purchases budget for metal for the month of December.

Question d. Compute the budgeted cash payments, for purchases of direct material, that would appear on the December cash budget.

Question e. Compute budgeted Accounts Payable at December 31.

Question f. Compute budgeted cash collections, from sales, that would appear on the December cash budget.

Question g. Compute Accounts Receivable at December 31.