Q1. "Wimble Don Racquets Inc." is a manufacturer and seller of tennis racquets. They make four different models: Murray, Federer, Djokovic, and Nadal. Information about the production of these Racquets is in the following table: Tennis Raquet Labour Labour Composite Composite ($17/hr) ($2/g) (hrs) 1.5 2 Murray Federer vestigate Djokovic Nadal 2.5 4 Djokovic Nadal $ 25.50 $ 34.00 $ 42.50 $ 68.00 Tennis Raquet Price Total Sales (Units) Murray $75.00 3000 Federer $ 85.00 4000 $ 95.00 5000 $105.00 6000 $ $ $ 3.5 $ 2 3 3 4.00 6.00 6.00 7.00 String (cm) 4 5 6 7 String ($0.45/cm) $ 1.80 $ 2.25 $ 2.70 $ 3.15 Production is constrained by having only 14,500 hours of labour, 18,000 grams of composite (i.e. plastic), and 26,000 cm of string (i.e. nylon). Do the following using excel and solver and other functions. Please consider each independently and put each in a separate worksheet: a. Assuming there are no constraints, what is the profit? b. Assuming you must keep within the constraints, what is the optimal production amount of each model to maximize profits and what are the profits? c. Assuming you can reduce the labour hours required for the Djokovic and Nadal models to 2 hours, what is the optimal product per model and what is the profit? d. At what price level per racquet for the Nadal racquet would it just marginally result in the optimal solution being to produce only Nadal racquets and what would the profit be? Explain how you did this calculation. e. Assuming there is a labour shortage and only 8,000 hours of labour are available, what is the ontimal solution.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Concept explainers

Question

Please help me to solve this problem

Q1. "Wimble Don Racquets Inc." is a manufacturer and seller of tennis racquets. They make four
different models: Murray, Federer, Djokovic, and Nadal. Information about the production of these
Racquets is in the following table:
Tennis Raquet Labour Labour Composite Composite
($17/hr)
($2/g)
(hrs)
1.5
2
Murray
Federer
vestigate
Djokovic
Nadal
2.5
4
Djokovic
Nadal
$ 25.50
$ 34.00
$ 42.50
$
68.00
Tennis Raquet Price Total Sales
(Units)
Murray $75.00
3000
Federer $ 85.00
4000
$ 95.00
5000
$105.00 6000
$
$
$
3.5 $
2
3
3
4.00
6.00
6.00
7.00
String
(cm)
4
5
6
7
String
($0.45/cm)
$
1.80
$
2.25
$
2.70
$ 3.15
Production is constrained by having only 14,500 hours of labour, 18,000 grams of composite (i.e.
plastic), and 26,000 cm of string (i.e. nylon).
Do the following using excel and solver and other functions. Please consider each independently and
put each in a separate worksheet:
a. Assuming there are no constraints, what is the profit?
b.
Assuming you must keep within the constraints, what is the optimal production amount of each
model to maximize profits and what are the profits?
c. Assuming you can reduce the labour hours required for the Djokovic and Nadal models to 2
hours, what is the optimal product per model and what is the profit?
d. At what price level per racquet for the Nadal racquet would it just marginally result in the
optimal solution being to produce only Nadal racquets and what would the profit be? Explain
how you did this calculation.
e. Assuming there is a labour shortage and only 8,000 hours of labour are available, what is the
ontimal solution.

Expert Solution

Step 1

Comment -

Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question and specify the other subparts (up to 3) you’d like answered.

Corporate Profit -

Revenue is the money that a business would make over the course of a specific time period from all of the services they provide or from the sale of their goods and services. The money that remains after a business deducts all of its costs from its income is referred to as its corporate profit.

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions