Sydney's Bakery operates a small business that bakes and sells a variety of goods within a...

 
 

Transcribed Image Text:

Sydney's Bakery operates a small business that bakes and sells a variety of goods within a major city. Sydney is trying to gain a better understanding of the business's profits with the goal of identifying opportunities. Sydney has hired you to examine the operations and the respective financial data and to provide your expertise and recommendations. Analysis of business operations and profitability requires an understanding of the types of costs that are incurred. Sydney has not had the opportunity to evaluate costs from a management accounting perspective. Recall that classifying costs on the basis of the following, can be very beneficial to support decision making. 1. Behaviour - fixed or variable 1. Traceability direct or indirect 2. Financial reporting - product or period 3. For product costs classify as DM, DL, MOH Following is a list of costs that Sydney's Bakery incurs for one of the most popular baked goods - Cinnamon Buns. Annual business license fee Utilities for bakery Sugar Eggs Accounting Consultant Wages-Dish Washer Insurance for baker Costs Rent for bakery Flour Yeast Butter Vegetable Oil (spraying pans) Wages - Baker Wages - Counter sales staff Sydney's Bakery has received an order for 50 dozen cinnamon buns to be delivered to a local post- secondary institution. Following is information relevant to this order. Materials Traceable Materials $28 - Flour $12-sugar $8-milk $5 - Butter $3-eggs Non-traceable materials * Water Yeast Ground cinnamon Brown Sugar Oil for baking pans *Note: The non-traceable materials have a total estimated cost of $27 for this order. Labour Following is information for the staff working on the day the order is produced & sold. All staff support the production, sales and delivery of all baked products except the baker whose work time is dedicated to this order. Other Expenses Baker - $35/hr for 6 hours Support staff (dishwasher, counter sales) - $15/hour for 8 hours Delivery staff - $15/hour - 3 hours Manager - $260/day Rent and insurance for the bakery total $3500/month. Utilities $1280/month. Tip: daily calculations are based on the following calculation: cost * 12/365-round to the whole dollar Operational information Sydney's Bakery applies overhead on the basis of Baker's Direct Labour hours. The estimated Baker DL hours for the year are 1,500 hours. The estimated manufacturing overhead is $126,000. For the reporting period, the actual overhead costs totalled $132,480 and actual Baker DL hours were recorded as 1,560. Operational results Sydney's Bakery has provided you with activity and respective costs for three months below. 3 March 3,000 per unit 6.60 Sales in units Sales revenue Less: COGS Gross Margin Less Operating XP Insurance Rent Dep'n Advertising Salaries Total Oper XP Net Income January February 2,800 per unit 3,400 per unit $ 18,480 $ 6.60 $ 22,440 $ 6.60 $ 19,800 $ (6,160) $ (2.20) $ 12,320 $ (7,480) $ (2.20) $ (6,600) $(2.20) $ 14,960 $ 13,200 $ 800 $ 0.29 $ $ 1,800 $ 0.64 $ $ 700 $ 0.25 $ $ 640 $ 0.23 $ $ 7,100 $ 2.54 $ $(11,040) $ 1,280 800 $ 0.24 $ 800 $ 0.53 $ 1,800 $ 0.21 $ 700 650 1,800 700 670 $0.20 $ 7,850 $(11,820) $ 3,140 $ 2.31 $ 7,350 $(11,300) $ 1,900 0.27 0.60 0.23 0.22 2.45 Case Assignment Requirements Requirement #1 For this requirement, you will analyze and classify costs that have been reported in Sydney Bakery's financial statements. 1. Classify the various costs in relation to the production and sale of cinnamon buns (one of several goods produced and sold). Any one of the costs may be classified under several classification types. A table has been included at the end of this document which you can copy and past into your response for convenience. Place an "x" in the respective cell representing the classification type. Be sure to refer back to the case details provided for details on the costs and the classification types. Requirement #2 This requirement focuses on the special order of 50 dozen cinnamon buns. Based on the information presented in the case: 1. Determine the total manufacturing costs for the order of 50 dozen cinnamon buns. 2. Calculate the total manufacturing cost on a per dozen basis 3. Calculate the total manufacturing costs on a per cinnamon bun basis. Requirement #3: Based on the "Operational Information" provided in the case: 1. Calculate the pre-determined overhead rate (PDOHR) 2. Determine if manufacturing overhead (MOH) was over or under applied. 3. Develop the Journal Entry necessary to close out the manufacturing overhead account. Requirement #4: Based on the "Operational Results" information presented for January, February, and March, complete the following: 1. Identify the variable, fixed and mixed costs 2. Develop the cost formula for each of the mixed costs using the high-low method? 3. Calculate the total cost for each mixed cost at an activity level of 3,600? 4. Prepare a contribution margin format income statement for the month of March (3,000 units). Requirement #5: Based on the Contribution Margin format income statement you created in requirement #4, calculate the following: 1. Total Contribution Margin 2. Contribution Margin per unit 3. Contribution Margin ratio 4. Break even point in $ and in units 5. Number of units and sales $ required to achieve monthly profits of $4,200. Requirement #6 Below are 2 separate proposals being considered. Create a contribution margin format income statement for the following using the March information as the base for each proposal to support your analysis and recommendations: 1. The Baker believes that if she uses pecans and raisins in the basic cinnamon bun recipe, that sales volume will increase by 25%. The additional cost per cinnamon bun for the pecans and raisins will be $.20. What will be the new net income under this proposal? Would you recommend proceeding with this proposal? 2. Sydney believes that if she increases the monthly advertising cost by $300 that the bakery will experience a 15% sales volume increase. What will the new net income be under this proposal? Would you recommend proceeding with this proposal? Tip: use the following format for the CM Income Statement 1) Total 1) per unit Revenue/cost 2) Total 2) per unit Sydney's Bakery operates a small business that bakes and sells a variety of goods within a major city. Sydney is trying to gain a better understanding of the business's profits with the goal of identifying opportunities. Sydney has hired you to examine the operations and the respective financial data and to provide your expertise and recommendations. Analysis of business operations and profitability requires an understanding of the types of costs that are incurred. Sydney has not had the opportunity to evaluate costs from a management accounting perspective. Recall that classifying costs on the basis of the following, can be very beneficial to support decision making. 1. Behaviour - fixed or variable 1. Traceability direct or indirect 2. Financial reporting - product or period 3. For product costs classify as DM, DL, MOH Following is a list of costs that Sydney's Bakery incurs for one of the most popular baked goods - Cinnamon Buns. Annual business license fee Utilities for bakery Sugar Eggs Accounting Consultant Wages-Dish Washer Insurance for baker Costs Rent for bakery Flour Yeast Butter Vegetable Oil (spraying pans) Wages - Baker Wages - Counter sales staff Sydney's Bakery has received an order for 50 dozen cinnamon buns to be delivered to a local post- secondary institution. Following is information relevant to this order. Materials Traceable Materials $28 - Flour $12-sugar $8-milk $5 - Butter $3-eggs Non-traceable materials * Water Yeast Ground cinnamon Brown Sugar Oil for baking pans *Note: The non-traceable materials have a total estimated cost of $27 for this order. Labour Following is information for the staff working on the day the order is produced & sold. All staff support the production, sales and delivery of all baked products except the baker whose work time is dedicated to this order. Other Expenses Baker - $35/hr for 6 hours Support staff (dishwasher, counter sales) - $15/hour for 8 hours Delivery staff - $15/hour - 3 hours Manager - $260/day Rent and insurance for the bakery total $3500/month. Utilities $1280/month. Tip: daily calculations are based on the following calculation: cost * 12/365-round to the whole dollar Operational information Sydney's Bakery applies overhead on the basis of Baker's Direct Labour hours. The estimated Baker DL hours for the year are 1,500 hours. The estimated manufacturing overhead is $126,000. For the reporting period, the actual overhead costs totalled $132,480 and actual Baker DL hours were recorded as 1,560. Operational results Sydney's Bakery has provided you with activity and respective costs for three months below. 3 March 3,000 per unit 6.60 Sales in units Sales revenue Less: COGS Gross Margin Less Operating XP Insurance Rent Dep'n Advertising Salaries Total Oper XP Net Income January February 2,800 per unit 3,400 per unit $ 18,480 $ 6.60 $ 22,440 $ 6.60 $ 19,800 $ (6,160) $ (2.20) $ 12,320 $ (7,480) $ (2.20) $ (6,600) $(2.20) $ 14,960 $ 13,200 $ 800 $ 0.29 $ $ 1,800 $ 0.64 $ $ 700 $ 0.25 $ $ 640 $ 0.23 $ $ 7,100 $ 2.54 $ $(11,040) $ 1,280 800 $ 0.24 $ 800 $ 0.53 $ 1,800 $ 0.21 $ 700 650 1,800 700 670 $0.20 $ 7,850 $(11,820) $ 3,140 $ 2.31 $ 7,350 $(11,300) $ 1,900 0.27 0.60 0.23 0.22 2.45 Case Assignment Requirements Requirement #1 For this requirement, you will analyze and classify costs that have been reported in Sydney Bakery's financial statements. 1. Classify the various costs in relation to the production and sale of cinnamon buns (one of several goods produced and sold). Any one of the costs may be classified under several classification types. A table has been included at the end of this document which you can copy and past into your response for convenience. Place an "x" in the respective cell representing the classification type. Be sure to refer back to the case details provided for details on the costs and the classification types. Requirement #2 This requirement focuses on the special order of 50 dozen cinnamon buns. Based on the information presented in the case: 1. Determine the total manufacturing costs for the order of 50 dozen cinnamon buns. 2. Calculate the total manufacturing cost on a per dozen basis 3. Calculate the total manufacturing costs on a per cinnamon bun basis. Requirement #3: Based on the "Operational Information" provided in the case: 1. Calculate the pre-determined overhead rate (PDOHR) 2. Determine if manufacturing overhead (MOH) was over or under applied. 3. Develop the Journal Entry necessary to close out the manufacturing overhead account. Requirement #4: Based on the "Operational Results" information presented for January, February, and March, complete the following: 1. Identify the variable, fixed and mixed costs 2. Develop the cost formula for each of the mixed costs using the high-low method? 3. Calculate the total cost for each mixed cost at an activity level of 3,600? 4. Prepare a contribution margin format income statement for the month of March (3,000 units). Requirement #5: Based on the Contribution Margin format income statement you created in requirement #4, calculate the following: 1. Total Contribution Margin 2. Contribution Margin per unit 3. Contribution Margin ratio 4. Break even point in $ and in units 5. Number of units and sales $ required to achieve monthly profits of $4,200. Requirement #6 Below are 2 separate proposals being considered. Create a contribution margin format income statement for the following using the March information as the base for each proposal to support your analysis and recommendations: 1. The Baker believes that if she uses pecans and raisins in the basic cinnamon bun recipe, that sales volume will increase by 25%. The additional cost per cinnamon bun for the pecans and raisins will be $.20. What will be the new net income under this proposal? Would you recommend proceeding with this proposal? 2. Sydney believes that if she increases the monthly advertising cost by $300 that the bakery will experience a 15% sales volume increase. What will the new net income be under this proposal? Would you recommend proceeding with this proposal? Tip: use the following format for the CM Income Statement 1) Total 1) per unit Revenue/cost 2) Total 2) per unit

Answer rating: 100% (QA)

Requirement 1 Classifying Costs Sure thing Heres how Id classify the costs for the production and sale of cinnamon buns Cost Behavior Traceability Financial Reporting Product Classification Annual bus... View the full answer