Your Task **All masks have a print of a character popular with children. The license amount is paid directly to the companies with the exclusive rights to the characters. The Poppy Pig and Captain Sweatpants masks are expected to be the top sellers this season. You were recently hired as an assistant controller at Safe Smiles Protective Masks Inc. ("Safe Smiles"). Your employer manufactures and sells a single product, unique and fun protective face masks for children. The masks use a special antimicrobial fabric and are well known for being extremely comfortable and durable for kids. As face masks have become the new norm during the COVID era, demand has been booming. With the return of kids to school and the upcoming cold and flu season, management expects demand to remain strong for the foreseeable future. The first task you have been assigned in your new role is to prepare the master budget for the quarter ended December 31", 2020 You have assembled the following information. Information on sales All operating expenses are paid during the month in cash, with the exception of the depreciation, as it is not a cash expense. Due to the planned introduction of a new mask line for teens in 2021, the company will be purchasing a new set of industrial sewing machines in October for $23,000 and a new print machine in November for $12,000. The equipment will not be used until 2021. The machines were purchased ahead of schedule, as Safe Smiles did not want to experience any delays in case a future shutdown. The company has a policy to declare a dividend of $10,000 on the last day of each quarter, which will be paid in the first month of the next quarter. The masks sell for $18 each. Recent and budgeted sales (in units) are as follows: August (actual) September (actual) October November December January February 7,550 8,200 7,850 8,100 8,300 7,680 7,400 Balance Sheet of sofe Smiles Protective Masks Inc. at September 30, 2020: Assets Cash Accounts receivable Inventory- Raw Materials Inventory. Finished Goods PP&E Accumulated depreciation 22.500 130,500 30,704 48 S15 All sales are on credit, with no discount. The company has found that only 30% of a month's sales are collected by month-end. An additional 50% is collected in the month following the sale, and the remaining 20% 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. 254,000 171.000 183.000 TOTAL ASSETS $415,219 Liabilities and Equity Bank loan Accounts payable, purchases Dividends payable Capital stock, no par Retained earning 21,973 10,000 150,000 233,246 TOTAL LIABILITIES AND EQUITY $415,219 Additional information on cash requirements and financing REQUIRED: Information on inventory and production Inventories of finished goods on hand at the end of each month are to be equal to 50% of the following months budgeted sales. As of September 30, 2020, the company had 3,925 masks in finished goods inventory. The company has no work-in-process (WIP) inventory. Each mask requires 1/10th of a yard of antimicrobial silver ion fabric, which the company purchases for $55.00 per yard. Note-both the mask and the straps are made from this same fabric so there is only one raw material used to make the product. It is company policy to keep enough fabric in raw materials to meet 70% of the next month's production needs. As of September 30th, Safe Smiles had 558.25 yards of fabric in raw materials inventory. Purchases of raw materials are paid for as follows: 50% in the month of purchase and the remaining 50% in the following month. Each mask requires 0.25 labour hours (15 minutes) to assemble by hand. Employees who make the masks are paid $15.00 per hour, and never 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 $1.00 per mask in production, and the fixed component is $17,000 per month. The $17,000 of fixed manufacturing overhead includes depreciation of $2,000 per month on the sewing machines and graphic print machines used to manufacture the masks. 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 Safe Smiles' other monthly operating expenses are given below: Variable Prepare the following for the company for the quarter ending December 31": 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 & Selling and Administrative Budget h. Cash Budget Schedule of Cost of Goods Manufactured 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 Earings Statement 1 Budgeted Balance Sheet at December 31, 2020 License $1.75 per mask sold ". Fixed: NOTES Wages and salaries Utilities Insurance Depreciation (S&A) Miscellaneous $10,000 $2.500 $800 $1,200 $1,000 Preparing the schedules For items (a) through (h) show each of the 3 months and a total column for the whole quarter (ended December 31). It may be helpful to prepare(a) through (e) on one individual worksheet in Excel, to make building and referencing easier. For items through ikl, show only for the quarter ended December 31, 2020