(Management Accounting)

1. Recommend all the calculations are done using Excel Spreadsheet

Case - Food Truck Business You and your best friend recently graduated with a business diploma. Both of you have similar interest to start a business. Both of you have interest in food since young. Right after graduation you and your future business partner did some market research on the food industry and found out that one of the fastest growing segment in the food industry is the food truck segment which attracts mostly the young professionals and college students. Research shown that this particular market segment have the spending power and is willing to spend on quality, fast serving, and healthy food. You and your partner decided to start a food truck business offering quick and healthy burgers targeted at the young adult market. Due to the high risk and very competitive market segment the partners decided, for the initial launch, to offer 2 items on the menu. The decision to limit the offering to two items is because it is easier to manage and more importantly maintain the quality of food to ensure that first time customers will have a pleasant experience and hope it will encourage repeat purchase. If the business goes well in the first three months, the plan is to gradually increase the number of items to the menu. Below are descriptions of the two items that will be offered: 1. Sesame Bun Burger (SBB) - 80 g quality beef pattie wrapped with two toasted whole wheat bread, topped with fresh lettuce, tomato, cheddar cheese, and special sauce served with french fries and carbonated soft drinks. 2. Soy Burger (SB) - 100g of soya based pattie wrapped with two thick slices of sour dough bread and topped with sauted button mushroom served with sweet potato chips and iced green tea. Below are forecasted cost data: I. Initial start-up costs: A. Food truck: i. Purchase food truck for RM70,000, paid RM10,000 cash and taking RM60,000 loan from Small and Medium Enterprise (SME) program with an interest of 6% per annum with monthly interest payment. ii. Estimated truck life 7 years with salvage value of RM20,000 iii. Straight-line depreciation B. Lap top computer with business programs: i. Purchase price - RM3,600; paid cash ii. Estimated life - 3 years with no salvage value iii. Straight-line depreciation II. Standard raw material cost per serving: Pattie Bread Fries Drinks Menu Sesame Bun Burger (SBB) Soy Burger (SB) RM3.00 | RM0.50 RM1.50 RM1.00 Toppings RM1.50 RM 1.50 RM0.80 RM1.00 Packaging RM0.20 RM0.20 RM0.50 RM0.50 Page 2 of 6 III. Budgeted monthly fixed operating costs: Budgeted Fixed Operating Cost Per Month Activities Operating costs Advertising RM 50.00 Local council business permit RM 80.00 Gas RM 200.00 Food truck maintenance RM 200.00 Petrol RM 200.00 Utilities RM 100.00 Food truck loan - interest payment RM ? Worker salary* RM 4,000.00 Food truck depreciation expense RM Computer depreciation expense RM ? *worker costs the whole operation will be managed by the two partners whom will be paid a monthly salary of RM 2,000. Besides the monthly salary, the two partners will also share profit earned. C. Cost Control (8 marks) The partners believed that controlling cost is critical to their long term profitability. The following are budgeted and actual activities and cost for the first month of business: SBB SB Actual Actual Budget 1050 Budget 450 Units 990 475 Page 4 of 6 RM Pattie Bread Toppings Fries Packaging Drinks O/H RM RM RM RM RM RM RM 3,150 525 1,575 840 210 525 4,074 RM RM RM RM 3.100 520 1,550 800 200 500 4.014 RM RM RM 675 450 675 450 RM RM RM RM RM RM RM 730 490 720 455 96 250 1.746 RM RM RM RM RM 90 225 1,746 RM Required: 1. Prepare a cost performance report for the first month of operation (Compare actual costs with flexible budgeted costs). II. Discuss the possible causes for significant costs variances (favourable and unfavourable) and recommend correction actions to rectify the costs variances. D. Short-term Profit Planning - Cost Volume Profit Analysis (15 marks). After the first three months of operations, forecast sales for the coming Month #4 expected to be low due to the period after personal income tax filling. Potential customers are expected to cut down on eating out for the month of April. April Expected Sales Data Menu 1. Sesame Bun Burger (SBB) 2. Soy Burger (SB) Total servings Expected Sales (units) 900 386 1,286 Price/unit RM 15.57 RM 14.37 Required: 1. Although total expected sales will be lower, expect the sales mix for its 2 items will remain the same as the first 3 months expected sales volume. Calculate how many units SBB and SB to break-even for the coming Month #4. Assuming the costs do not change. II. Estimate how many of each product you need to sell if your target before tax profit for Month #4 is RM 5,000 (assuming your business exempted from tax for the first year). III. Due to the lower expected sales for Month #4, the partners intend to run a promotion event to capture new customers from other food vendors. The promotion is "buy any three (3) servings get one (1) free servings of the lower priced item". With the promotion forecasted combine sales will increase from 1,286 combine paid servings to 1,886 combine paid servings (excluding the free serving). Do you recommend to the partners to go ahead with the "buy 3 get 1 free" promotion? Support your decision with cost/benefit analysis. Note: You can use the "with/without" income comparison approach or the incremental benefit/costs approach). Page 5 of 6 IV. When applying the concept of "Cost-Volume-Profit" analysis for multiple products. certain assumptions have to be considered. Describe these assumptions and explain why these assumptions are important in assisting managers in short-term decision making Page 6 of 6 Case - Food Truck Business You and your best friend recently graduated with a business diploma. Both of you have similar interest to start a business. Both of you have interest in food since young. Right after graduation you and your future business partner did some market research on the food industry and found out that one of the fastest growing segment in the food industry is the food truck segment which attracts mostly the young professionals and college students. Research shown that this particular market segment have the spending power and is willing to spend on quality, fast serving, and healthy food. You and your partner decided to start a food truck business offering quick and healthy burgers targeted at the young adult market. Due to the high risk and very competitive market segment the partners decided, for the initial launch, to offer 2 items on the menu. The decision to limit the offering to two items is because it is easier to manage and more importantly maintain the quality of food to ensure that first time customers will have a pleasant experience and hope it will encourage repeat purchase. If the business goes well in the first three months, the plan is to gradually increase the number of items to the menu. Below are descriptions of the two items that will be offered: 1. Sesame Bun Burger (SBB) - 80 g quality beef pattie wrapped with two toasted whole wheat bread, topped with fresh lettuce, tomato, cheddar cheese, and special sauce served with french fries and carbonated soft drinks. 2. Soy Burger (SB) - 100g of soya based pattie wrapped with two thick slices of sour dough bread and topped with sauted button mushroom served with sweet potato chips and iced green tea. Below are forecasted cost data: I. Initial start-up costs: A. Food truck: i. Purchase food truck for RM70,000, paid RM10,000 cash and taking RM60,000 loan from Small and Medium Enterprise (SME) program with an interest of 6% per annum with monthly interest payment. ii. Estimated truck life 7 years with salvage value of RM20,000 iii. Straight-line depreciation B. Lap top computer with business programs: i. Purchase price - RM3,600; paid cash ii. Estimated life - 3 years with no salvage value iii. Straight-line depreciation II. Standard raw material cost per serving: Pattie Bread Fries Drinks Menu Sesame Bun Burger (SBB) Soy Burger (SB) RM3.00 | RM0.50 RM1.50 RM1.00 Toppings RM1.50 RM 1.50 RM0.80 RM1.00 Packaging RM0.20 RM0.20 RM0.50 RM0.50 Page 2 of 6 III. Budgeted monthly fixed operating costs: Budgeted Fixed Operating Cost Per Month Activities Operating costs Advertising RM 50.00 Local council business permit RM 80.00 Gas RM 200.00 Food truck maintenance RM 200.00 Petrol RM 200.00 Utilities RM 100.00 Food truck loan - interest payment RM ? Worker salary* RM 4,000.00 Food truck depreciation expense RM Computer depreciation expense RM ? *worker costs the whole operation will be managed by the two partners whom will be paid a monthly salary of RM 2,000. Besides the monthly salary, the two partners will also share profit earned. C. Cost Control (8 marks) The partners believed that controlling cost is critical to their long term profitability. The following are budgeted and actual activities and cost for the first month of business: SBB SB Actual Actual Budget 1050 Budget 450 Units 990 475 Page 4 of 6 RM Pattie Bread Toppings Fries Packaging Drinks O/H RM RM RM RM RM RM RM 3,150 525 1,575 840 210 525 4,074 RM RM RM RM 3.100 520 1,550 800 200 500 4.014 RM RM RM 675 450 675 450 RM RM RM RM RM RM RM 730 490 720 455 96 250 1.746 RM RM RM RM RM 90 225 1,746 RM Required: 1. Prepare a cost performance report for the first month of operation (Compare actual costs with flexible budgeted costs). II. Discuss the possible causes for significant costs variances (favourable and unfavourable) and recommend correction actions to rectify the costs variances. D. Short-term Profit Planning - Cost Volume Profit Analysis (15 marks). After the first three months of operations, forecast sales for the coming Month #4 expected to be low due to the period after personal income tax filling. Potential customers are expected to cut down on eating out for the month of April. April Expected Sales Data Menu 1. Sesame Bun Burger (SBB) 2. Soy Burger (SB) Total servings Expected Sales (units) 900 386 1,286 Price/unit RM 15.57 RM 14.37 Required: 1. Although total expected sales will be lower, expect the sales mix for its 2 items will remain the same as the first 3 months expected sales volume. Calculate how many units SBB and SB to break-even for the coming Month #4. Assuming the costs do not change. II. Estimate how many of each product you need to sell if your target before tax profit for Month #4 is RM 5,000 (assuming your business exempted from tax for the first year). III. Due to the lower expected sales for Month #4, the partners intend to run a promotion event to capture new customers from other food vendors. The promotion is "buy any three (3) servings get one (1) free servings of the lower priced item". With the promotion forecasted combine sales will increase from 1,286 combine paid servings to 1,886 combine paid servings (excluding the free serving). Do you recommend to the partners to go ahead with the "buy 3 get 1 free" promotion? Support your decision with cost/benefit analysis. Note: You can use the "with/without" income comparison approach or the incremental benefit/costs approach). Page 5 of 6 IV. When applying the concept of "Cost-Volume-Profit" analysis for multiple products. certain assumptions have to be considered. Describe these assumptions and explain why these assumptions are important in assisting managers in short-term decision making Page 6 of 6