Your Task You were recently hired as an assistant controller at the Fuzzy Slipper Sock Company ("the Company"). Your employer manufactures and sells a single product: super comfortable and fuzzy slipper socks! With people stuck at home because of the COVID-19 pandemic, the Company has seen a significant increase in demand for their fuzzy slipper socks. The socks pair perfectly with pajama pants, creating an extremely comfortable, stay-at-home look. The first task you have been assigned in your new role is to prepare the master budget for the quarter ended March 31, 2021. You have assembled the following information. Information on sales The slipper socks sell for $15 each. Recent and budgeted sales (in units) are as follows: November (actual) December (actual) January February March April May 12,000 13,500 11,000 12,500 11,300 10,500 9,500 All sales are on credit, with no discount. The company has found that only 25% of a month's sales are collected by month-end. An additional 60% is collected in the month following the sale, and the remaining 15% is collected in the second month following the sale. Bad debts have been negligible, so they can be ignored for the purposes of the budget. Information on inventory and production Inventories of finished goods on hand at the end of each month are to be equal to 70% of the following months budgeted sales. As of December 31, 2020, the company had 7,700 pairs of fuzzy slipper socks in finished goods inventory. The company has no work-in-process (WIP) inventory. Each pair of slipper socks requires 8/10th of a yard of fabric (a fleecy, wool blend fabric), which the company purchases for $10.50 per yard. It is company policy to keep enough fabric in raw materials to meet 50% of the next month's production needs. As of December 31st, the Company had 4,820 yards of fabric in raw materials inventory. Purchases of raw materials are paid for as follows: 60% in the month of purchase and the remaining 40% in the following month. Each pair of socks requires only 0.167 labour hours (10 minutes) to assemble by hand, as most of the work is done by machine. Employees making the socks are paid $14.60 per hour, and do not work overtime. The Company has enough casual/on-call workers that they can call in if additional work is required. Manufacturing overhead includes all the costs of production other than direct materials and direct labour. The variable component of manufacturing overhead is $0.35 per pair of socks in production, and the fixed component is $13,200 per month. The $13,200 of fixed manufacturing overhead includes depreciation of $3,300 per month on the sewing machines used to manufacture the socks. Direct labour hours is used as an allocation base for assigning manufacturing overhead to units produced. Information on selling and administrative expenses and cash outlays The Company's other monthly operating expenses are given below: Variable: Commission expense $0.50 per pair of slipper socks sold Fixed Wages and salaries Utilities Insurance Depreciation (S&A) Advertising $12,000 $3,500 $900 $1,500 $800 **The sales team receives a commission for each pair of slipper socks sold. The Company sells primarily to retailers who place large orders. The Company introduced this incentive to its sales team last year, and it has proven to be a great motivational tool that helped to skyrocket sales. All operating expenses are paid during the month in cash, with the exception of the depreciation, as it is not a cash expense. The Company was recently involved in a lawsuit related to a customer who received a pair of socks with a dead cockroach found inside the left sock. The Company decided to settle out of court and is due to pay that customer $5,000 for emotional damages in January. This anticipated liability was accrued for in December 2020. Additionally, the Company has decided to purchase a new air conditioning unit for the manufacturing facility for $16,000. Payment for the air conditioner will be made in February, but the air conditioner will not be delivered until April 1, 2021. At the end of December 2020, the Company declared its year-end dividend to shareholder for $25,000 to be paid during the first month of the following quarter. In March 2021, the Directors plan to declare a dividend of $10,000, which will be paid to shareholders in April 2021. Balance Sheet of the Fuzzy Slipper Sock Company os at December 31, 2020: Assets Cash Accounts receivable Inventory - Raw Materials Inventory - Finished Goods PP&E Accumulated depreciation $24,000 178,875 50,610 95,000 290,000 (85,000) 205,000 TOTAL ASSETS $553,485 Liabilities and Equity Bank loan Accounts payable, purchases Accrued liability (lawsuit) Dividends payable Capital stock, no par Retained earnings $1,000 39,984 5,000 25,000 275,000 207,501 TOTAL LIABILITIES AND EQUITY $553,485 Additional information on cash requirements and financing Management of the Company requires a minimum ending cash balance each month of $24,000. The Company can borrow money from its bank at 6% annual interest. All borrowing must be done at the beginning of a month, and repayments must be made at the end of a month. Borrowings and repayments of principal must be in round $1,000 amounts. Interest is computed and paid when any repayments occur. Round all interest payments to the nearest whole dollar. Compute interest using whole months, not days. The company wishes to use any excess cash to pay loans off as rapidly as possible. REQUIRED: C. Prepare the following for the company for the quarter ending March 315. a. Sales Budget and Schedule of Expected Cash Collections b. Production Budget Direct Materials Budget and Schedule of Expected Cash Disbursements d. Direct Labour Budget (inclusive of expected labour disbursements) e. Manufacturing Overhead Budget (inclusive of expected overhead disbursements) f. Ending Finished Goods Inventory Budget g. Selling and Administrative Budget h. Cash Budget i. Schedule of Cost of Goods Manufactured j. Budgeted Income Statement (with the cost of goods sold computation included in the income statement) You may ignore income taxes for the purposes of this budget k. Budgeted Retained Earnings Statement