Question: Excel! Part 1: Profit Calculation - Design a spreadsheet to calculate profit with the following requirements. You can design the spreadsheet any way you want.

Excel!

Part 1: Profit Calculation - Design a spreadsheet to calculate profit with the following requirements. You can design the spreadsheet any way you want. The spread sheet should be organized properly. All calculations must be done using appropriate formula. However, you must keep track of the following items Items Descriptions 1 Number of toolsets sold - initialize to 100 2 Price Per toolset - initialize to $40.00 Fixed cost to produce toolset - initialize to $150.00 4 Variable cost for each toolset- initialize to $25.00 5 Profit -(To be Calculated) Make Font type Calibri, and Font size 24 for all fields 7 Give appropriate captions to all fields 8 Implement the above spreadsheet, naming the tab as Profit 9 Please put your First Name, Last Name and Student Number on this Excel Work sheet
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
