Question

BUS A202 project assignment Master budget The Columbo Company manufactures a single model trench coat. Projected sales in units for the first 5 months of fiscal 2021 are as follows. January 18,000 February 20,000 March 15,000 April 8,000 May 6,000 Each trench coat sells for $145. All sales are on account. The Accounts Receivable balance on January 1, 2021 was $45,000 and is considered 100% collectible in the month of January. The Cash balance on January 1, 2021 was $48,000. 90% of Sales are collected in cash during the month of sale and 8% in the month after sale. The remaining 2% of Sales are considered Bad Debts. Bad Debt expense is recognized each month based on recorded Sales for that month. Bad Debts are considered Variable Costs. Finished Goods inventory shall be maintained at 80 percent of the following month’s sales. Finished Goods inventory on January 1, 2021 was 14,400 units. There are two Raw Materials utilized in the production of each trench coat as follows: Polyester: 5 yards per unit at a standard cost of $17 per yard. Lining: 3 yards per unit at a standard cost of $2 per yard. Raw Materials will be maintained at 10% of the material needed to fulfill the following month’s production requirements. Inventory on hand January 1, 2021 were 9,800 yards of Polyester and 5,880 yards of lining. All material purchases are paid in the month following the month of purchase. Accounts Payable at January 1, 2021 was $938,400 all of which was related to material purchases to be paid in January. Direct Labor required to produce a single trench coat is 2 direct labor hours. The standard pay rate is $11 per hour. Labor is paid in the month the hours are worked. Overhead each month consists of both variable and fixed costs. Variable overhead is based on Direct Labor Hours. A summary of overhead costs is as follows: Monthly Fixed Component Variable Component ($ per Direct Labor Hour) Supplies $1.00 Utilities .75 Maintenance $3,000 .50 Wages & Benefits 52,000 Depreciation 12,000 Taxes 5,000 Other 10,000 2.00 Total $82,000 $4.25 All Overhead costs will be paid in the month they are incurred. Selling, General and Administrative (SG&A) expenses have both variable and fixed components. The variable component is based on the number of units sold. The cost behavior of SG&A is as follows: Monthly Fixed Component Variable Component ($ per unit sold) Salaries & Benefits $38,000 Quality costs $3.00 Depreciation 2,000 Advertising .75 Other 10,000 1.50 Total $50,000 $5.25 All SG&A costs will be paid in the month incurred. The Company has a $1 million line of credit with the bank. The Company is required to maintain a minimum balance of $50,000 at the bank at all times. Any bank borrowings must be made in increments of $1,000. Repayment of any borrowings will be budgeted when there is available cash. Interest on the line of credit is 5%. A full month of interest will be budgeted to be paid for any month in which there is a loan balance. Borrowings are assumed to occur on the first of the month and repayments on the last day of the month. There were no amounts drawn against the line on January 1, 2021. Bank fees of $150 per month are expected. This amount is NOT included in the SG&A budget as outlined above and is considered a fixed expense. Other specific cash expenditures are planned as follows: January: Dividends of $500,000. February: Tax payment of $655,000. March: The Company will purchase a new sewing system at a cost of $150,000. Required: Note: Excel templates have been provided to assist you in completing these schedules. 1. Prepare the following budgets in good form for each of the first three months of 2020 and show first quarter totals for each budget: Sales Budget Production budget Material requirements budget Direct Labor budget Overhead budget Selling, General & Administrative expense budget Cash budget 2. Prepare a pro-forma income statement for the first quarter of 2020 in good form. (Prepare the Income statement in the contribution format.) Disregard income taxes.

Answer 1

The question requires the creation of a master budget and a pro-forma income statement for the Columbo Company's trench coat manufacturing operations, considering sales projections, costs, and financial policies.

Step-by-step explanation:

The question asks for the preparation of various components of a master budget for the Columbo Company, which manufactures trench coats. This includes creating a sales budget, production budget, material requirements budget, direct labor budget, overhead budget, and a cash budget, as well as a pro-forma income statement for the first quarter of the fiscal year 2021. These budgets will incorporate variable and fixed costs, projected sales, and other operational components, such as accounts receivable, direct materials, and overhead expenses. These budgets are crucial for financial planning and help the company manage its resources effectively.