Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. open the lp worksheet (linear programming) in the

Open the LP Worksheet (Linear Programming) in the Excel file. A manufacturer makes two products,...

50.1K

Verified Solution

Question

Accounting

image
image
Open the LP Worksheet (Linear Programming) in the Excel file. A manufacturer makes two products, X and Y. Each X requires 6 hours in the assembly department, 3 hours in the spraying department and 1 hour in the finishing department. For Y, the time required in each of these departments is 12 hours, 4 hours and 5 hours respectively. We are also told that each X makes 40 profit and each Y makes 105. This information is summarised in the following table: X Y Total time available (hrs) 6 12 2400 Assembly (time in hrs) Spraying (time in hrs) Finishing (time in hrs) 3 4 1200 1 5 800 Profit 40 105 This information is in the EXCEL worksheet. You will need to use it to produce suitable equations. State the Profit Equation. B C F m 1 2 3 Product 4 Y 105 12

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

1. For the equation x2+y2?2x?4y?11=0, do the following. (a) Find the center (h,k) and radius r of...

Basic Math
Q

Discuss the use of Lanthanide shift reagents (LSR) in NMR spectroscopy, both how it works and...

Chemistry
Q

Rentz Corporation is investigating the optimal level of current assets for the coming year. Management expects...

Finance
Q

3 Find the surface area of the rectangular polyhedron below SA 7 cm cm 3...

Geometry
Q

The half-life of Palladium-100 is 4 days. After 16 days a sample of Palladium-100 has...

Algebra
Q

If the expected sales volume for the current period is 6,600 units, the desired ending...

Accounting
Q

Statement of Cash Flows-Indirect Method The comparative balance sheet of Olson-Jones Industries Inc. for December...

Accounting
Q

Prester Corporation has budgeted production for next year as follows: Second Third Fourth Production in...

Accounting
Q

Which of the following budget includes the balance in Accounts Receivable and Accounts Payable accounts?...

Accounting
Q

Gable Corporate Services uses EVA to evaluate the performance of division managers. For the Media...

Accounting
Q

Based on the given chat, Need your help on how to explain on Time Interest...

Finance
Q

6. Problem 9.06 Click here to read the eBook: Preferred Stock PREFERRED STOCK VALUATION Farley...

Finance