You were recently hired as an assistant controller at Safe Smiles Protective Masks Inc. (Safe Smiles)....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 The masks sell for $20 each. Recent and budgeted sales (in units) are as follows: August (actual) September (actual) 7,550 8,200 7,850 8,100 8,300 7,680 7,400 October November December January February 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. 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 30h, 2020, the company had 3,925 masks in finished goods inventory. The company has no work-in-process (WIP) inventory. Each mask requires 1/10" of a yard of antimicrobial silver ion fabric, which the company purchases for $65.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 30", Safe Smiles had 558 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 $16.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,500 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 selNng and administrative expenses and cash outlays Safe Smiles' other monthly operating expenses are given below: Variable: License $1.75 per mask sold ** Fixed: Wages and salaries Utilities $10,000 $2,500 $800 Insurance Depreciation (S&A) Miscellaneous $1,200 $1,000 **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. 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 $10,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. Bolance Sheet of Safe Smiles Protective Masks Inc. ot September 30, 2020: Assets Cash 22,500 Accounts receivable 145,000 36,286 53,421 Inventory - Raw Materials Inventory - Finished Goods PP&E Accumulated depreciation 254,000 (71,000) 183,000 TOTAL ASSETS $440,207 Liabilities and Equity Bank loan Accounts payable, purchases Dividends payable Capital stock, no par Retained earnings 25,967 10,000 150,000 254,240 TOTAL LIABILITIES AND EQUITY $440,207 Additional information on cash requirements and financing Management of Safe Smiles requires a minimum ending cash balance each month of $22,000. The company can borrow money from its bank at 5% 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: Prepare the following for the company for the quarter ending December 31": a. Sales Budget and Schedule of Expected Cash Collections b. Production Budget c. 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 8 Selling and Administrative Budget h. Cash Budget 1. Schedule of Cost of Goods Manufactured 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 The masks sell for $20 each. Recent and budgeted sales (in units) are as follows: August (actual) September (actual) 7,550 8,200 7,850 8,100 8,300 7,680 7,400 October November December January February 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. 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 30h, 2020, the company had 3,925 masks in finished goods inventory. The company has no work-in-process (WIP) inventory. Each mask requires 1/10" of a yard of antimicrobial silver ion fabric, which the company purchases for $65.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 30", Safe Smiles had 558 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 $16.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,500 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 selNng and administrative expenses and cash outlays Safe Smiles' other monthly operating expenses are given below: Variable: License $1.75 per mask sold ** Fixed: Wages and salaries Utilities $10,000 $2,500 $800 Insurance Depreciation (S&A) Miscellaneous $1,200 $1,000 **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. 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 $10,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. Bolance Sheet of Safe Smiles Protective Masks Inc. ot September 30, 2020: Assets Cash 22,500 Accounts receivable 145,000 36,286 53,421 Inventory - Raw Materials Inventory - Finished Goods PP&E Accumulated depreciation 254,000 (71,000) 183,000 TOTAL ASSETS $440,207 Liabilities and Equity Bank loan Accounts payable, purchases Dividends payable Capital stock, no par Retained earnings 25,967 10,000 150,000 254,240 TOTAL LIABILITIES AND EQUITY $440,207 Additional information on cash requirements and financing Management of Safe Smiles requires a minimum ending cash balance each month of $22,000. The company can borrow money from its bank at 5% 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: Prepare the following for the company for the quarter ending December 31": a. Sales Budget and Schedule of Expected Cash Collections b. Production Budget c. 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 8 Selling and Administrative Budget h. Cash Budget 1. Schedule of Cost of Goods Manufactured
Expert Answer:
Answer rating: 100% (QA)
i Schedule of Cost of Goods Manufactured j Budgeted Income Stat... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-0078025518
2nd edition
Authors: Stacey Whitecotton, Robert Libby, Fred Phillips
Posted Date:
Students also viewed these accounting questions
-
You were recently hired as an assistant controller at Just Tables (JT). JT sells one product, dining room tables made out of red cedar. You have been charged with preparing a cash budget for the...
-
You were recently hired as the new Human Resources manager for a new company that has been in business for two weeks. The CEO is looking to you and your expertise in compensation and benefits to...
-
You were recently hired as the assistant treasurer for Victor, Inc. Yesterday, the treasurer was injured in a bicycle accident and is now hospitalized, unconscious. Your boss, Mr. Fernandes, just...
-
In 2020, A corporation gave the following fringe benefits to its employees (Non-resident alien not engaged in trade/business): To managerial employees - P1,500,000 To rank and file employees -...
-
What decisions are made by marketing managers? How does marketing research help in making these decisions?
-
How do (digital) viruses work?
-
With reference to the preceding exercise, (a) construct a \(95 \%\) confidence interval for \(\beta\), the elongation per thousand pounds of tensile stress; (b) find 95% limits of prediction for the...
-
Tranter, Inc. is considering a project that would have a ten-year life and would require a $1,200,000 investment in equipment. At the end of ten years, the project would terminate and the equipment...
-
Bond X is a bond with a coupon rate of 18 percent that makes annual payments. It has a poor rating that bond issuer might not pay the interest and/or principal payments. Bond Y is a bond with a...
-
In April 2018, Dan is audited by the IRS for the year 2016. During the course of the audit, the agent discovers that Dan's deductions for business travel and entertainment are unsubstantiated and a...
-
Define Chiral catalyst. What is a Chiral reagent?
-
What is the strategy behind using alternative media in an IMC campaign?
-
What are the strategic uses of social media in an IMC campaign?
-
How has the Internet changed the way brands do business?
-
Why is Internet marketing considered an extension of traditional tactics?
-
To be effective and relevant to the target, mobile must do what?
-
What should financial records provide to the clinic? In your opinion.
-
Problem 2. (0.6 points, 0.2 points for each question) (a) A company turns its inventory 2 times a month. Its months-of-supply = Its days-of-supply = Please show your analysis below: _months. days. (1...
-
Refer to the information in E6-18 for Tiago. Suppose the product mix has shifted to 40/30/30. Required: 1. Determine the new weighted-average contribution margin per unit. 2. Determine the number of...
-
On January 1, 2013, you deposited $8,000 in a savings account. The account will earn 8 percent annual compound interest, which will be added to the fund balance at the end of each year. Required: 1....
-
StorSmart Company makes plastic organizing bins. The company has the following inventory balances at the beginning and end of March: Additional information for the month of March follows: Raw...
-
Company G has a hardware business. The balance sheet at the beginning of the financial year showed the position in Table 2.23. Show the adjustments, in the columns provided, for each of the following...
-
This information has been taken from the companys books as at 31 December 20X1, but the information below has not been allowed for. (a) Inventory at 31 December 20X1 is 20,000. (b) Plant and...
-
The information has been taken from the companys books as at 31 December 20X1, but the following has not been allowed for. (a) Inventory at the end of the year is 25,000. (b) Audit fees owing...
Study smarter with the SolutionInn App