Your task is to design a spreadsheet that provides detailed information on monthly production, inventory, lost sales, and the different cost categories and solve a linear optimization model for minimizing the total cost of meeting demand over the next year. Compare your solution with the level production strategy of producing 9,100 units each month. Interpret the Sensitivity report, and conduct an appropriate study of how the solution will be affected by changing the assumption of the lost sales costs. Summarize all your results in a report to Ms. Burke.

The struter partnership has total partners’ equity of $510,000, which is made up of main, capital, $400,000, and frist, capital, $110,000. the partners share net income and loss in a ratio of 80% to main and 20% to frist. on november 1, adison is admitted to the partnership and given a 15% interest in equity and a 15% share in any income and loss. prepare journal entries to record the admission of adison for a 15% interest in the equity and a 15% share in any income and loss under the following independent assumptions. (1) record the admission of adison with an investment of $90,000 for a 15% interest in the equity and a 15% share in any income and loss. (2) record the admission of adison with an investment of $120,000 for a 15% interest in the equity and a 15% share in any income and loss. (3) record the admission of adison with an investment of $80,000 for a 15% interest in the equity and a 15% share in any income and loss.