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

Abnormal profits, explain the terms abnormal profits and normal profits

explain the terms abnormal profits and normal profits

Graph of supply and demand, Draw the supply and demand graph for pizza, the...

Draw the supply and demand graph for pizza, then answer the questions below. SUPPLY OF AND DEMAND FOR PIZZA Quantity Supplied Price Quantity Demanded 300 $15.00 100 240 12.00 180 1

Mechanical engineer who is anticipating paying, A mechanical engineer who i...

A mechanical engineer who is anticipating paying for his daughter's college education plans to start depositing money now (year 0) and continue through year 17. If he deposits $ 50

To compare prices what is consumers ability, How has the Internet revolutio...

How has the Internet revolution affected the workings of businesses, consumers, and government in a free market economy? Specifically, how has Internet affected businesses' ability

Illustrate about perfectly competitive market firm, Why might a perfectly ...

Why might a perfectly competitive market firm be willing to run at a loss in the short run? The assumptions of a PCM firm should be outlined in order to end that the PCM firm i

• What are the main goods and services the United States tra, I am working ...

I am working on a project for my class and this week discussion is on international trade and exports. what I am needing is the information for the 1970s

Benefits and disadvantages of each scenario, Do you think that public admin...

Do you think that public administrators should be restricted to only laid down rules in the discharge of their duties as espoused by Max Weber or should they have some amount of di

Production, mention and explain four factors that determine the volume of p...

mention and explain four factors that determine the volume of production.

#title.williams managerial discretion model, The different between williams...

The different between williams managerial discretion model and baumol''s sales maximization model

Describe the structural unemployment, Describe the Structural unemployment ...

Describe the Structural unemployment Individuals who are unemployed as their skills are no longer in demand where they live. This kind mainly results in longer spells and may r

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