Estimate the maximum possible daily profit, Macroeconomics

Assignment Help:

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

 


Related Discussions:- Estimate the maximum possible daily profit

Determine the exchange rate, Determine the exchange rate When a currenc...

Determine the exchange rate When a currency is freely floating, the central bank doesn't have to set monetary policy to alter the external value of the currency unless instruct

Trade between the two countries, Given the above trade between the two coun...

Given the above trade between the two countries, explain the trade effects on product prices, and factor incomes. Why do these effects occur?

Circular flow of income, Explain a circular flow of income in a frugal econ...

Explain a circular flow of income in a frugal econmomy with diagram

Economic assesment, can you tell me how this works, i am struggling to writ...

can you tell me how this works, i am struggling to write my report in economics and i would like to know how much does it cost some help

Impulse response functions, The final and most important part of the method...

The final and most important part of the methodology is the impulse response functions which will provide the most information with regards to the aim of the project. In order to a

Consumer surplus and producer surplus, Suppose the inverse demand curve for...

Suppose the inverse demand curve for a market is equal to p = 100 -- 0.3Q. The inverse market supply curve is p = 20 + 0.5Q. 1. Calculate the equilibrium price and quantity;

Keynesian fiscal policy, Assume the economy has a GDP of $11,500 billion.  ...

Assume the economy has a GDP of $11,500 billion.  The unemployment rate is at 7.3% and has been slowly rising for the last 6 months.  Inflation was at 2.3% one year ago but has sin

Determine the current in the neutral conductor, A 415V, 3-phase, 4 wires, s...

A 415V, 3-phase, 4 wires, star-connected system supplies three resistive loads as shown in Figure. Determine (a) The current in each line and (b) The current in the neutr

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd