Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is a case study. I dont expect the expert to answer all of these but I was not sure how to split the case

This is a case study. I dont expect the expert to answer all of these but I was not sure how to split the case into multiple questions and to avoid ANY confusion.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Nice-CTees Corporation is a private corporation formed in 2005 for the purpose of selling chocolate products to local and regional supermarkets Nice Tees Corporation is located in Central Trinidad and has a warehouse in Arma The mission is to start manufacturing their chocolates with local ingredients to geta Triniflavour. They hope to be an all-round service of producing and selling and to be the premier chocolate in the Caribbean Nice Tees Corporation is a family owned business with Mr Party Boumas CEO. The team comprise of Mr Bourne's brother. James Bourne. the chocolate who studied at the Trinidad and Tobago Hospitally and Tourism Institute. The other departments are managed by employees who have been working with them from inception. In 2010, the employees with the Trade Union representative negotiated a 5-day work week for all employees. As at the end of 2008. Nice-C Tees used Traditional Costing System, which they found to be inefficient As January 2009, they switched to Activity Based Costing System and has been using it ever since. Due to the switch in conting methods, Nice-C-Tested multiple.com drivers, which has a direct cause effect relationship in applied overhead con The company just signed two contracts to supply the Mega Chan Supermarket and Value Chain Supermarkets. The Sales and Marketing Manager Mark Fordi planning for the new year in terms of production needs to meet the company's Sales demand. He is also trying to determine ways in which the company profis might be increased in the new year. December 2012. they marketed a dark chocolate which the company sold 712.000 boxes at an average price of 5t5.50 per box The variable expenses were $5.200.200 and the feed expenses were $820,000. The Christmas season tusly has special orders from various clients Nice-C-Tees has a sales mix of different types of chocolates with a flud cost of $5.500,000. They are white, dark and pure. Althree types are in high demand both localy and regionally. They are talks to expand to the international market Currently the marketing Manager is doing marketing research to determine the potential customer base. win at of the extra work one of the chocolate machines have been doing. Nice C Tees is looking at an option to the retain or replace the main machine. The operations manager estimates that the existing machines has 2 more years of useful life. This machine produces 50 unts and sels 50 units per day, whereas the possible replacement machine produces twice that much Sales are equal to production on these units and production fun for 2 weeks cach year. The replacement machine would have a 2 year useful The Finance Manager, held a meeting with all department heads and the CEO the operational budgets and to present a cash flow position of the company. They are trying to maintain cash flow of a minimum balance of $6.000.000 in order for the business to fund the requirements of each department Nice-Tees han agreement with the bank that loans taken must be in increments of 1,000 ats interest. Any loan take will become due at the end of the calendar you. Al the end of the month, each department has to provide their budget to the commitee for review and approval. During the meeting the Manufacturing Manager highlighted there were some discrepancies with what they budgeted and the actual and that they needed to try to be more accurate when budgeting. The report presented showed a wide variance in costs between the budget and actuaires for the month of October. The CEO requested a cost of Goods Manufactured Schedule to supplement the Production Report that he wants to take to the Board of Directors meeting was noted that the materials purchased during the period was 45% of the beginning raw materials totalt The Finance Manager noticedere are discrepancies with budgeted figures and what was reported in the last of the Management Accounts. The Finance Manager is asking for answers. All the Production Manager remembers is that both the budget and actualfed cost were $100,000 A Directive given from the Board of Directors is to plan for the first three months of 2020. There are several budgets which must be completed for the company to formalize an operational strategy for cash, material purchases etc. the meeting ended with a managers agreeing to submit the required documents This is a comprehensive case on Nice-C-Tee Corporation. The data answer the questions for your assignment are to be extracted from within the case and also Appendix and on this paper, Assignment Questions [100 Marks) 1. Determine the overhead rates and the actual cost assigned for each of the activity cost pools using ABC system Marks) 2. Prepare a cost of goods Manufactured (4 Marks) 3. You are to prepare the weighted average contribution margin ratio and breakeven point in dollars for the company using the same Marks) 4. What is the product's contribution margin ratio (Round to nearest whole percentage) Income (H0contribution margin perunt 5 Mars 5. What is the company's break even point in units and indolers for this product? 2 Marks) & management wanted to increase its income from this product by 65% how many additional units would have to be sold to reach this income level? 14 Marks) 7. Prepare schedules to the Operations Manager, showing the consequences of Nice-Tees replacing the machine and again or loss from based in (10 Marks) For each department a budget has to be prepared. Prepare budgets for the (59 Marks) (a) Sales (0) Production (c) Drect Materials (d) Manuacturing Overhead (*) Selling and Administrative Collections (9) Payments h) Cash 9. Prepare a flexible Budget at the level of 8,000 units prepare a lexible budget variance report for guter ending December 2019 (6 marks) Ads Nut Check SIS Pwede Deliveryone Packa Se Centre Ne ofructe de Neem Com PO Dehyder Palace New Mewah Wake CUS 5 5 95 New Machine Posts Saksa Prawach Sake Me 5 December CallSchedule in the month of sale Join the mathole son in the Selber & Admite Fired Expo Advertise 100.00 Other 3,000.00 Total Direct Labour Cout January February March 4,037,040.00 6,055.360.00 9,788.400.00 224,280 336,420 435,040 Total Indirect Labour Hours January February March Manufacturing Overhead per month Indirect Materials Indirect Labour Utilities Maintenance Salaries Property Taxes Insurance Maintenance 30 cents per labour hour 50 cents per labour hour 45 cents per labour hour 25 cents per labour hour 42.000.00 2.675.00 1.200,00 1.300,00 Depreciation per month using new machine cost (rounded) Comparative Figures - Quartier Ending December 2019 Budgeted Units 10,000.00 Actual Units 8.000.00 Budgeted Variable Costs Direct Labour Direct Materials Manufacturing Overhead Variable Costs. Other 50,000.00 60,000.00 75,000.00 62,000,00 Actual Variable Costs Direct Labour Direct Materials Manufacturing Overhead Variable Costs - Other 40,000.00 63.500.00 55.000.00 29.600.00 Nice-CTees Corporation is a private corporation formed in 2005 for the purpose of selling chocolate products to local and regional supermarkets Nice Tees Corporation is located in Central Trinidad and has a warehouse in Arma The mission is to start manufacturing their chocolates with local ingredients to geta Triniflavour. They hope to be an all-round service of producing and selling and to be the premier chocolate in the Caribbean Nice Tees Corporation is a family owned business with Mr Party Boumas CEO. The team comprise of Mr Bourne's brother. James Bourne. the chocolate who studied at the Trinidad and Tobago Hospitally and Tourism Institute. The other departments are managed by employees who have been working with them from inception. In 2010, the employees with the Trade Union representative negotiated a 5-day work week for all employees. As at the end of 2008. Nice-C Tees used Traditional Costing System, which they found to be inefficient As January 2009, they switched to Activity Based Costing System and has been using it ever since. Due to the switch in conting methods, Nice-C-Tested multiple.com drivers, which has a direct cause effect relationship in applied overhead con The company just signed two contracts to supply the Mega Chan Supermarket and Value Chain Supermarkets. The Sales and Marketing Manager Mark Fordi planning for the new year in terms of production needs to meet the company's Sales demand. He is also trying to determine ways in which the company profis might be increased in the new year. December 2012. they marketed a dark chocolate which the company sold 712.000 boxes at an average price of 5t5.50 per box The variable expenses were $5.200.200 and the feed expenses were $820,000. The Christmas season tusly has special orders from various clients Nice-C-Tees has a sales mix of different types of chocolates with a flud cost of $5.500,000. They are white, dark and pure. Althree types are in high demand both localy and regionally. They are talks to expand to the international market Currently the marketing Manager is doing marketing research to determine the potential customer base. win at of the extra work one of the chocolate machines have been doing. Nice C Tees is looking at an option to the retain or replace the main machine. The operations manager estimates that the existing machines has 2 more years of useful life. This machine produces 50 unts and sels 50 units per day, whereas the possible replacement machine produces twice that much Sales are equal to production on these units and production fun for 2 weeks cach year. The replacement machine would have a 2 year useful The Finance Manager, held a meeting with all department heads and the CEO the operational budgets and to present a cash flow position of the company. They are trying to maintain cash flow of a minimum balance of $6.000.000 in order for the business to fund the requirements of each department Nice-Tees han agreement with the bank that loans taken must be in increments of 1,000 ats interest. Any loan take will become due at the end of the calendar you. Al the end of the month, each department has to provide their budget to the commitee for review and approval. During the meeting the Manufacturing Manager highlighted there were some discrepancies with what they budgeted and the actual and that they needed to try to be more accurate when budgeting. The report presented showed a wide variance in costs between the budget and actuaires for the month of October. The CEO requested a cost of Goods Manufactured Schedule to supplement the Production Report that he wants to take to the Board of Directors meeting was noted that the materials purchased during the period was 45% of the beginning raw materials totalt The Finance Manager noticedere are discrepancies with budgeted figures and what was reported in the last of the Management Accounts. The Finance Manager is asking for answers. All the Production Manager remembers is that both the budget and actualfed cost were $100,000 A Directive given from the Board of Directors is to plan for the first three months of 2020. There are several budgets which must be completed for the company to formalize an operational strategy for cash, material purchases etc. the meeting ended with a managers agreeing to submit the required documents This is a comprehensive case on Nice-C-Tee Corporation. The data answer the questions for your assignment are to be extracted from within the case and also Appendix and on this paper, Assignment Questions [100 Marks) 1. Determine the overhead rates and the actual cost assigned for each of the activity cost pools using ABC system Marks) 2. Prepare a cost of goods Manufactured (4 Marks) 3. You are to prepare the weighted average contribution margin ratio and breakeven point in dollars for the company using the same Marks) 4. What is the product's contribution margin ratio (Round to nearest whole percentage) Income (H0contribution margin perunt 5 Mars 5. What is the company's break even point in units and indolers for this product? 2 Marks) & management wanted to increase its income from this product by 65% how many additional units would have to be sold to reach this income level? 14 Marks) 7. Prepare schedules to the Operations Manager, showing the consequences of Nice-Tees replacing the machine and again or loss from based in (10 Marks) For each department a budget has to be prepared. Prepare budgets for the (59 Marks) (a) Sales (0) Production (c) Drect Materials (d) Manuacturing Overhead (*) Selling and Administrative Collections (9) Payments h) Cash 9. Prepare a flexible Budget at the level of 8,000 units prepare a lexible budget variance report for guter ending December 2019 (6 marks) Ads Nut Check SIS Pwede Deliveryone Packa Se Centre Ne ofructe de Neem Com PO Dehyder Palace New Mewah Wake CUS 5 5 95 New Machine Posts Saksa Prawach Sake Me 5 December CallSchedule in the month of sale Join the mathole son in the Selber & Admite Fired Expo Advertise 100.00 Other 3,000.00 Total Direct Labour Cout January February March 4,037,040.00 6,055.360.00 9,788.400.00 224,280 336,420 435,040 Total Indirect Labour Hours January February March Manufacturing Overhead per month Indirect Materials Indirect Labour Utilities Maintenance Salaries Property Taxes Insurance Maintenance 30 cents per labour hour 50 cents per labour hour 45 cents per labour hour 25 cents per labour hour 42.000.00 2.675.00 1.200,00 1.300,00 Depreciation per month using new machine cost (rounded) Comparative Figures - Quartier Ending December 2019 Budgeted Units 10,000.00 Actual Units 8.000.00 Budgeted Variable Costs Direct Labour Direct Materials Manufacturing Overhead Variable Costs. Other 50,000.00 60,000.00 75,000.00 62,000,00 Actual Variable Costs Direct Labour Direct Materials Manufacturing Overhead Variable Costs - Other 40,000.00 63.500.00 55.000.00 29.600.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting Reporting Analysis And Decision Making

Authors: Shirley Carlon, Rosina Mladenovic Mcalpine, Chrisann Palm, Lorena Mitrione, Ngaire Kirk, Lily Wong

5th Edition

0730313743, 978-0730313748

More Books

Students also viewed these Accounting questions

Question

3.2 Discuss the strategic importance of technology in HRM.

Answered: 1 week ago