Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please use excel. Date Assigned: Tuesday, June 30, 2020 Date Due: Wednesday, July 01, 2020 before class. No late homework will be accepted. Homework 19

please use excel. image text in transcribed
Date Assigned: Tuesday, June 30, 2020 Date Due: Wednesday, July 01, 2020 before class. No late homework will be accepted. Homework 19 Please notice that all work must be shown in a professional way with attention to detail No credit will be given for incomplete or disorderly work Please use a cover sheet stating your name, course number, date due, and homework number Unstapled homework will not be collected as this is part of the assignment All work must be individual with emphasis on numerical accuracy This is an Excel based assignment that must be submitted following the stated guidelines Please notice that late homework (after collected by the instructor) will incur into a 25% late fee 1. Problem One: Prats Design is a small design company that produces two lines of electronic devices, model A, and model B. After preliminary research, the marketing department expects the demand for model A to be at least 84 units per day. In contrast, the demand for model B is expected to be at least 54 units per day. In addition, due to limitations in the assembly line, the company cannot exceed 235 units for model A, and 130 for model B respectively. Because of an upcoming technology event, the company has a contractual obligation to send at least 315 units every day. If the sale of each model A yields a $77 profit, and the sale of each model B results in a $88 profit, how many units of each model should the company produce to maximize daily profits? 2. Problem Two: Fiterman Furniture is a small company that produces two lines of smart desks, model A, and model B. After preliminary research, the marketing department expects the demand for model A to be at least 100 units per day. In contrast, the demand for model B is expected to be at least 39 units per day. In addition, due to limitations in the assembly line, the company cannot exceed 415 units for model A, and 295 for model B respectively. Because of an upcoming technology event, the company has a contractual obligation to send at least 350 units every day. If the sale of each model A yields a $254 profit, and the sale of each model Bresults in a $425 profit, how many units of each model should the company produce to maximize daily profits

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

Auditing Principles And Techniques

Authors: Sanjib Kumar Basu, Andrei Alexandrescu

1st Edition

8177581783, 9788177581782

More Books

Students also viewed these Accounting questions