{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Unit 2 Grading Template - 149597900000 6380000 3.54E 022...

This preview shows pages 1–8. Sign up to view the full content.

Part1 Page 1 Part 1 Pts Earned Pts Possible File named Problem2.xls 1 1 Data set copied correctly 2 2 Formatting (heading and prices) correct 3 3 Cell formulas used 3 3 Total price correct 1 1 Total 10 10

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Smoothie Price (\$) Bought Jamaican Jammer \$3.50 1 Carribean Craze \$3.80 2 Strawberry Squeeze \$4.20 1 Raspberry Rhapsody \$4.10 3 Blueberry Sunset \$3.70 1 Pineapple Passion \$3.70 4 Total Price Paid \$46.10
Part2 Page 3 Part 2 Pts Earned Pts Possible Layout copied correctly 0 1 Mass/distance constants entered correctly 0 1 Cell formulas used 0 3 Named cells used (for constants) 0 3 Forces computed correctly 0 2 Total 0 10

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
TAB] Page PAGE] Constants 0 Earth (kg) 5.97E+024 7.36E+022 Moon (kg) 7.36E+022 5.97E+024 Sun (kg) 1.99E+030 Cameron Diaz (kg) 54.5 Me 56 Mass 1 (kg) 5.97E+024 Mass 2 (kg) 7.36E+022 Distance (m) 384403000 Force (N) 1.98E+020 Gravitational Constant (Nm2kg-2) Gravitational Constant 6.672x10-11 Nm2kg-2 Force between Earth and Moon (N)
TAB] Page PAGE] Earth-Moon Distance 384403000 Earth-Sun Distance 149597900000 Earth-Cameron Distance 6380000 Me-Celeb Distance 5.97E+024 54.5 1.99E+030 5.97E+024

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 149597900000 6380000 3.54E+022 533.32 Force between Earth and Sun (N) Force between Cameron Diaz and Earth (N) Force between Me and <Favorite Celeb> Part3 Page 6 Part 3 Pts Earned Pts Possible Constraints (6 total, 1 point each) 6 Correct target cell chosen (total profit) 3 Target cell is maximized 3 Changing cells chosen correctly 3 Total 15 YEARLY PRODUCTION/PROFIT DATA Model # Produced 9-3 Sedan € 18,675.00 € 25,900.00 € 7,225.00 3000 9-3 Convertible € 30,046.00 € 39,995.00 € 9,949.00 4100 9-5 Wagon € 24,267.00 € 34,695.00 € 10,428.00 4000 9-5 Sedan € 25,463.00 € 33,995.00 € 8,532.00 6900 Total Cars Produced: 18000 Total Factory Profit: Unit Production Cost (in €) Retail Price (in €) Profit per Vehicle (in €) € 21,675,000.00 € 40,790,900.00 € 41,712,000.00 € 58,870,800.00 € 163,048,700.00 Total Profit Generated (in €)...
View Full Document

{[ snackBarMessage ]}