Format: Answer these questions using an Excel workbook and include a problem per sheet. Name the sheets with the corresponding problem number in the textbook, for instance 1-14 or 4-19. Many problems may include a solver solution. Follow the format in the excel document in Course Resources and used in class. Some problems in the textbook have additional questions that require a change some conditions in your solver set up, just copy the original problem to a new worksheet and solve the new conditions. Do not change the conditions in the initial solver set up, so the instructor can see all your work.

Chapter 1, 2 and 4

mm

MNS 407 Assignment Problems Week 1 Ch 1. Introduction Ch 2. An Introduction to Linear Programming Ch 4. Linear Programming Applications in Marketing, Finance, and Operations Management Chapter 1, Problem 13 13. Micromedia offers computer training seminars on a variety of topics. In the seminars each student works at a personal computer, practicing the particular activity that the instructor is presenting. Micromedia is currently planning a two-day seminar on the use of Microsoft Excel in statistical analysis. The projected fee for the seminar is $600 per student. The cost for the conference room, instructor compensation, lab assistants, and promotion is $9600. Micromedia rents computers for its seminars at a cost of $120 per computer per day. a. Develop a model for the total cost to put on the seminar. Let x represent the number of students who enroll in the seminar. b. Develop a model for the total profit if x students enroll in the seminar. c. Micromedia has forecasted an enrollment of 30 students for the seminar. How much profit will be earned if their forecast is accurate? d. Compute the breakeven point. Chapter 1, Problem 15 15. Preliminary plans are under way for the construction of a new stadium for a major league baseball team. City officials have questioned the number and profitability of the luxury corporate boxes planned for the upper deck of the stadium. Corporations and selected individuals may buy the boxes for $300,000 each. The fixed construction cost for the upper-deck area is estimated to be $4,500,000, with a variable cost of $150,000 for each box constructed. a. What is the breakeven point for the number of luxury boxes in the new stadium? b. Preliminary drawings for the stadium show that space is available for the construction of up to 50 luxury boxes. Promoters indicate that buyers are available and that all 50 could be sold if constructed. What is your recommendation concerning the construction of luxury boxes? What profit is anticipated? Chapter 2, Problem 15 15. Refer to the Par, Inc., problem described in Section 2.1. Suppose that Par, Inc., management encounters the following situations: a. The accounting department revises its estimate of the profit contribution for the deluxe bag to $18 per bag. b. A new low-cost material is available for the standard bag, and the profit contribution per standard bag can be increased to $20 per bag. (Assume that the profit contribution of the deluxe bag is the original $9 value.) c. New sewing equipment is available that would increase the sewing operation capacity to 750 hours. (Assume that 10A + 9B is the appropriate objective function.) If each of these situations is encountered separately, what is the optimal solution profit contribution? Summary of Par Inc. Problem in Section 2.1: Max 105 + 9D subject to (s.t.) 7105 + 1D 5630 Cutting and Dyeing 12S + 5D 5 600 Sewing 15 + 23D