help needed

Question 1 - Inventory control methods m Pork Bellies is considering manufacturing readymade meals in the new processing plant. The companyis planning on working 250 working days peryear and has devised the following estimates on sales of the new product: Daily Sales Probability 400 0.5 500 I 0.3 600 0.1 700 I 0.1 I The annual carrying cost per unit is $0.40 - Setup time to manufactu re the meals is 20 minutes for each of the 5 machines involved in preparing the meals and it costs $24.50 per hour for operators to setthe machines up. a M anu facturing overhead is charged out at a rate of $12.50 per machine hour. - The readymade meals are packaged in recyclable containers and post $3.00 per 10 pack. The containers are sourced from Western Australia and can take anywhere between 15 to 20 days to arrive and have the following probability estimates: Days to ll order Probability Days to fill order 15 1 5 17 i 8 19 20 Required: 1. Calculate the economic size for each production Fur. 2. When should an order for more containers be placed, based on expected values? m 3. How can ordering be handled to eliminate stock-outs 9 out of 10 times without holding large amounts of containers? 4. Explain the differences in the basic philospophies underlying the JlT and EOQ approaches to inventory management Probability 0.30- 0. 15 0.15 D. 15 0. 15 0.10 Question 2 - Linear programming Pork Bellies has been approached by Hopewell Hospital, who coordinate meals for regional and city hospitals. Hopewell hospital who have devised a meal plan wants Pork Bellies to supply them with ready-made meals. Pork Bellies in consultation with Hopewell Hospital have devised a meal plan where 5 types of meals will be supplied based on calories and common allergies. The meals are: 1800C, 1500C, 800C, Gluten Free (GF) and Gluten and Dairy Free (GDF) All meals go through the steps of food preparation, cooking and snap freezing. The time requirements per box of 20 meals is below as well as the available time, all in hours. 1800C 1500C 800C GF GDF Selling Price ($) 15 14.5 13 15 13 Direct material 7 6.5 4 3 2 Direct labour 2 2 1.5 4 2 Variable overhead 0.5 1.5 0.5 0.5 Fixed overhead 2 2 2 2 2 AvailableConstraints: 1800C 1500C 800C GF GDF Available (hours) Mixing 0.5 0.5 1 1,500 Spreading 1 1 0.5 5,000 Cooking 0.5 1.5 2 0.5 0.5 2,300 Packaging 1 1 1 1 1 2,000 Due to the limits in the number of workers who may have access to the building at any one time because of COVID-19, a maximum of 100 1800C meals and a minimum of 50 GF meals for the month can be made. Required: 1. Formulate a linear program to determine the expected mix of conference rooms to ensure the maximum profit will be created. Show all supporting calculations and solve using a computer package (eg solver in Excel) to derive the optimum solution 2. Formulate a second linear programming taking into consideration the COVID-19 limitations. 3. State the optimal mix and resulting profit. Discuss your resultsQuestion 3 - Correlation and regression Pork Bellies is continuing to re-evaluate all aspects of the business and would like you to look into staffing costs. Below is a summary of the monthly costs. Staff number Number of meals Staff cost ($) 20 700 27800 January 22 250 14000 February 10 200 12000 March 20 500 20000 April 24 650 23800 May 28 450 18400 June 16 50 20400 July 14 150 8200 August 24 350 18800 September 24 600 22200 October 16 300 16600 November 32 750 32200 December The Pork Bellies relevant range has been estimated to be between 300 and 600 meals.Required: 1. Draw a scatter diagram of Pork Bellies meals and staff costs and mark the relevant range 2. Use the high-low method to estimate the behaviour of Pork Bellies staff costs based on meal numbers within the relevant range. Use an equation to express the results of this estimation method. 3. Using excel or a similar program construct a regression analysis to estimate: a. The equation to predict staff costs based on the number of meals within the relevant range b. Based on the equation in 3 a) what would the staff cost be with 400 meals per month c. Using both activities - number of meals and staff numbers, determine what the staff cost, within the relevant range, would be. (- 4. Does the inclusion of the additional cost driver (staff number) improve the model? Explain your answer Question 4 ( _ mummy The Board of Directors would like your opinion on what strategic position Pork Bellies should now take reflecting on Case Study Part 1 and Case Study part 2. In your response consider short-term and long-term strategies the business may adopt. Include in your answer at least 2 options explaining how the strategy would be implemented and the likely outcome