Copy of Assignment 10 Data
xlsx
keyboard_arrow_up
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.
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?