Quiz 6 Due on Monday, 3/27, 30mins before class on Blackboard General requirement Your Excel file...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Quiz 6 Due on Monday, 3/27, 30mins before class on Blackboard General requirement Your Excel file must be executable. If your excel model is ran, it should generate the same results you submit. That means the spreadsheet has correct embedded formulae and Solver dialog boxes have all the inputs. If 'Solve' is clicked and your spreadsheet does not produce the reported results, a zero score will be assigned to quiz 6. Name the Excel file as "Quiz 6_Last Name.xlsx". Galaxy manufactures two toy models: Space Rays (sold for $15 each) and Zappers (sold for $8 each). It costs $7 to produce a Space Ray, and $3 to produce a Zapper. Manufacturing resources are limited to 1200 pounds of special plastic, and 40 hours of production time per week. Space Rays requires 2 lbs of plastic and 3 minutes of labor per unit. Zappers requires 1 pound of plastic and 4 minutes of labor per unit. In addition, there are two marketing requirements: Requirement 1: Total production cannot exceed 800 units. Requirement 2: Number of Space Rays cannot exceed number of Zappers by more than 450. Define S = Space Ray production quantity, Z = Zapper production quantity. Input and solve the profit-maximization model using Excel Solver. Provide your answers to the following questions in the model worksheet. 1) In the optimal strategy, how many Space Rays toy will be produced? How many Zappers toy will be produced? What is the maximum profit? 2) By implementing the optimal strategy, how many pounds of plastic and how many production hours will be used? Report the slack/surplus for all constraints. 3) Which constraints are binding constraints? Quiz 6 Due on Monday, 3/27, 30mins before class on Blackboard General requirement Your Excel file must be executable. If your excel model is ran, it should generate the same results you submit. That means the spreadsheet has correct embedded formulae and Solver dialog boxes have all the inputs. If 'Solve' is clicked and your spreadsheet does not produce the reported results, a zero score will be assigned to quiz 6. Name the Excel file as "Quiz 6_Last Name.xlsx". Galaxy manufactures two toy models: Space Rays (sold for $15 each) and Zappers (sold for $8 each). It costs $7 to produce a Space Ray, and $3 to produce a Zapper. Manufacturing resources are limited to 1200 pounds of special plastic, and 40 hours of production time per week. Space Rays requires 2 lbs of plastic and 3 minutes of labor per unit. Zappers requires 1 pound of plastic and 4 minutes of labor per unit. In addition, there are two marketing requirements: Requirement 1: Total production cannot exceed 800 units. Requirement 2: Number of Space Rays cannot exceed number of Zappers by more than 450. Define S = Space Ray production quantity, Z = Zapper production quantity. Input and solve the profit-maximization model using Excel Solver. Provide your answers to the following questions in the model worksheet. 1) In the optimal strategy, how many Space Rays toy will be produced? How many Zappers toy will be produced? What is the maximum profit? 2) By implementing the optimal strategy, how many pounds of plastic and how many production hours will be used? Report the slack/surplus for all constraints. 3) Which constraints are binding constraints?
Expert Answer:
Posted Date:
Students also viewed these general management questions
-
Consider the many moments of joy in the movie. Why include them? What risky acts of courage do Katherine, Mary and Dorothy take? How are they rewarded? The film shows the strong relationships that...
-
The advertising firm Rog & Co. had the following information available concerning its cash account for the month of July: Balance per Rog & Co. books, July 31 ..... $24,180.55 Outstanding checks...
-
Return to the facts of problem 67. Assume that Louise sells the stock on October 31, 2017 for $35 per share. Determine the tax consequences for Louise and Somerton on the date of sale. In Problem 67...
-
Mission statement; writing You have managed Indiana's Best Appliances franchises for 15 years and have 100 employees. Business has been profitable, but you are concerned that the Indianapolis...
-
As a marketing manager for one of the world??s largest automakers, you are responsible for the advertising campaign for a new energy-efficient sports utility vehicle. Your support team has prepared...
-
4. A controlled experiment was conducted to study the effect of treatment A and the effect of treatment B on the expected value of the response variable y which is normally distributed. Treatment A...
-
Mary is an accountant in Prestige Accounting Firm. Her employment contract contains a provision that prohibits her from doing accounting work for private clients or working for another accounting...
-
Your e-commerce platform is processing orders in real-time. You want to track the number of orders places by customers within specific time intervals. Questions : How can you use KSQLDB to calculate...
-
A material is subjected to a general state of plane stress. Express the strain energy density in terms of elastic components E, G, v and the stress components x, y, xy. gy -Sidong isd y rxy ASA surgi...
-
You are considering an investment which would entail $5,000 payments each year for 30 years. The investment will pay 7 percent interest. How much will this investment be worth at the end of the 30...
-
Campbell, J. In March 1976, plaintiff Albin Laaperi purchased a smoke detector from Sears. The detector, manufactured by the Pittway Corporation, was designed to be powered by AC (electrical)...
-
2. Consider the graph in Figure 3.21, in which each edge b and c- is labeled as a strong tie (S) or a weak tie (W). S According to the theory of strong and weak ties, with the strong triadic closure...
-
1 Without discounting cash flows to take into account the time value of money, how soon will MBC break even on the following customers? In all cases, assume that revenues and variable costs to staff...
-
Draw the major product for each of the following reactions: (a) (b) (c) 1) 9-BBN 2) H2O2, NaOH 1) Disiamylborane 2) H20, NaOH
Study smarter with the SolutionInn App