Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please solve this urgent . Production of each item. Total number of labour units Raw Material required. The unit price, unit cost, and unit profit.

please solve this urgent image text in transcribed

. Production of each item. Total number of labour units Raw Material required. The unit price, unit cost, and unit profit. Maximum Demand of item Total of labour units. Your total available raw material units. Here is an MS Excel worksheet that summarizes data: 1 Product 2 No. Produced 3 Labor 4 Raw Material 5 Unit Price 6 Unit Cost 7 Unit Profit 8 Demand 9 B E G Shirts Hats Coats Scarfs Gloves Gowns 120 197 89 372 400 56 2 3 4 1 2 5 2 1.5 4.8 0.7 2.5 9.7 17.49 49.99 110 9.99 19.95 250.95 6.59 25.35 48.99 3.45 9.95 105.55 10.9 24.64 61.01 6.54 10 145.4 250 356 400 1680 900 390 10 11 USED 2639 2766.3 12 Labor 13 Raw Materials AVAILABLE 4500 7430 PROFIT 26167.25 Questions: a. Give the formula for B12 &013. (5 Marks) b. How to determine that how much to manufacture each item to maximize your profit considering given labor and raw material available? (10 Marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

=+During a downturn?

Answered: 1 week ago