Copy of Assignment 10 Data

.xlsx

School

University of Nebraska, Lincoln *

*We aren’t endorsed by this school

Course

250

Subject

Industrial Engineering

Date

May 1, 2024

Type

xlsx

Pages

4

Uploaded by MegaTeam9258

Product Desktop Laptop Tablet Base Price/Unit 750.00 850.00 590.00 Discount 1.57% Price/Unit after Discount 738.24 836.67 580.75 Expense/Unit 460.00 705.00 480.00 $200 Margin/Unit 278.24 131.67 100.75 $15 $0 Units sold 33 77 106 $5,500 To Total Product Margins 9,181.91 10,138.73 10,679.36 $13,000 T $0 Tot Total Advertising Expense 3,750 $25,0 Sum of Product Margins 30,000.00 $30,0 Assume th rate.
Scenario Discount 0 Margin/Unit for Desktop 12.00% 50 Margin/Unit for Laptop -0.59% 0 Margin/Unit for Tablet 18.64% otal Product Margin for Desktop 16.44% Total Product Margin for Laptop -2.80% tal Product Margin for Tablet 18.64% 000 Sum of Product Margins 4.84% 000 Sum of Product Margins 1.57% hat the number of units sold is unaffected by the discount Find the discount necessary to achieve the following scenarios.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help