Estimate the maximum possible daily profit, Macroeconomics

Shambles have selected the "Mythical Beasts" range and decided to concentrate on "Pegasus" and "Phoenix." They would now like to find the right mix of these two products in order to maximise profit. Each toy has to go through two processes during manufacture: sewing and stuffing.

Pegasus takes 30 minutes to sew whilst Phoenix takes 20 minutes; there are 10 hours (600 minutes) available for sewing each day.

Pegasus takes 20 minutes to stuff whilst Phoenix takes 25 minutes; there are 10 hours (600 minutes) available for stuffing each day.

Pegasus generates £4 profit per toy whilst Phoenix generates £5 profit per toy.

What is the maximum possible daily profit, and how many of each product should be produced in order to achieve this?

Use "Solver" in Microsoft Excel to solve this problem. Include:

a print-out of cell values
a print-out of cell formulae
a print-out of the Solver dialogue box with optimisation conditions and constraints
an Answer Report from Solve
a statement of the answer in words

 

Posted Date: 3/20/2013 5:28:37 AM | Location : United States







Related Discussions:- Estimate the maximum possible daily profit, Assignment Help, Ask Question on Estimate the maximum possible daily profit, Get Answer, Expert's Help, Estimate the maximum possible daily profit Discussions

Write discussion on Estimate the maximum possible daily profit
Your posts are moderated
Related Questions
TRADE LIBERALISATION UNDER WTO: In  the Uruguay Round negotiations, India agreed to reduce tariff on a  large number of  commodities and  remove quantitative restrictions (QRs

Q. Show the Different kinds of unemployment? All unemployed individuals are presumed to belong to exactly one of these categories so that if we sum unemployment from each categ

Q. What do you mean by Exchange rate? Exchange rate is defined as the price of one unit of currency in terms of another currency. If one euro costs 1.5 USD then 1 USD costs 1/1

The following is the information from the national income accounts for a hypothetical country: GDP Rs. 6000.00 Gross Investment Rs. 800.00 Net Investment Rs. 200.00 Consumption Rs.


What is the difference between merchantilism and absolute theory?

Imagine a firm with the same cost structure but in each of the four market structures: Competitive, Monopolistically Competitive, Oligopoly, and a Monopoly. Using the concepts of c

The Concept of Taxation is explained below: Taxes are the general purpose, compulsory contributions by people to the public treasury (or national exchequer) to meet the expendi

The enrollment in a course offered by the College of Business is random and is described by the following probability distribution: there is a 9% chance of 18 students, 22% chance

Question 1: Consider a two-period, two-person pure exchange economy. Utility functions and endowments are given as follows. u1(x0; x1) = (x0x1)2 and e1 = (18; 4) u2(x0; x1) = ln x0