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

Report
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.
Hours Studied 6.0 Exam Difficulty 3.0 Expected Score 73.0 Hours Studied 10.0 Hours Studied 5.0 Exam Difficulty 5.0 Exam Difficulty 10.0 Expected Score 85.0 Expected Score 25.0 Hours Studied 9.0 Hours Studied 10.0 Exam Difficulty 5.0 Exam Difficulty 2.0 Expected Score 79.0 Expected Score 103.0 Create a formula in cell C13 that returns an expected score of 55 (use whole number, not 0.55) when hours studied is 0 and exam difficulty is 0. From there, make the formula so that every additional hour of studying adds 6 to the expected score and every additional degree of difficulty subtracts 6 from the expected score. Hint: If your formula in cell C13 is correct, these will be the correct exam scores under 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
Answers 10.5 11.2 9.8 8.3 6.7 73.0 Assuming an exam difficulty of 5.0, how many hours of studying are required to achieve an expected score of 88.0? Assuming an exam difficulty of 8.0, how many hours of studying are required to achieve an expected score of 74.0? The expected score is a 98.0, and the hours studied is 17.0, what is the exam difficulty? The expected score is a 59.0, and the hours studied is 9.0, what is the exam difficulty? 11.0 hours of studying results in an expected score of 81.0, what is the exam difficulty? Assuming 6.0 hours of studying and an exam difficulty of 3.0, what is the expected exam score?