A company may suddenly be faced with an unexpected dilemma such as a lack of materials needed for production. Making the optimal decision in view of a constraint on resources can be crucial to maximize profit until the situation eases or a new long-term plan is developed. Lets assume that Herta Company makes and distributes frozen gourmet foods. The company is the most famous for the two kinds of pies it makes. The basic pie uses 2 lbs. of berries and the deluxe pie uses 5 lbs. of the same berries. Herta Company currently has 6,000 lbs. of imported berries on hand. The company is planning to purchase another 6,000 lbs. of to make 1,000 basic pies and 2,000 deluxe pies. More information about the contribution margin for each type of pie is shown below.Pie Deluxe Pie Selling price $8.10 $13.90Less variable expensesDirect materials (ingredients) 2.00 5.00Direct labor 2.10 1.40Variable overhead (flour, etc.) 1.00 1.50Contribution margin $3.00 $6.00The company has just received word that the source of the berries has been shut down by regional disturbances. Consequently, the company will not be able to import the 6,000 lbs. it planned on using in the coming months production. Theres no other source of berries.Required:Computations (use Excel).Determine the optimal usage of the companys inventory of 6,000 lbs. of berries. Show your computations in good format. Compute the total contribution margin that the company would have earned if all 12,000 lbs. of berries were available. How many of each pie should Herta Company make and distribute in order to maximize the contribution margin? Compute the total contribution margin for the product mix that you recommend.Memo (use Word).Write a memo to the production manager explaining how to handle production for the next month. Refer to your analysis in your response. Write a four or five paragraph memo to the owner of the business. Start with an introduction and end with a recommendation. Each of the four or five paragraphs should have a heading.Short essay (use Word).Use the background material and do research as needed to comment on different types of limitations on resources a company may encounter and strategies to maximize profit.Start with an introduction and end with a summary or conclusion. Use headings.Assignment ExpectationsSubmission should include two files: (1) An Excel file; and (2) A Word document. The Word document shows the memo first and short essay last. Assume a knowledgeable business audience and use required format and length. Individuals in business are busy and want information presented in an organized and concise manner.* Note: See attachment Module 4 Case v1 with complete assignment instructions and Memo/ Essay Example Template.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]