Applying Excel: Exercise (Part 2 of 2) Requirement 2:
A
B
1
2
3
4
5
6
7
Chapter 11: Applying Excel
Data
Sales $45,000,000
Net operating income $4,500,000
Average operating assets$15,000,000
Minumum required rate of return 21%
Revise the data in your worksheet as follows:
If your formulas are correct, you should get the correct answers to the following questions.
a. What is the ROI?
b. What is the residual income? (Negative amount should be indicated by a minus sign.)
c. Why is the residual income positive?

Question 1 which of the following tasks use your roommate as a resource? choose all answers which apply. take order wash the mixer’s bowl and mix the dough spoon cookies onto the tray unload the cookies from the oven pack the cookies 1 points question 2 which of the following tasks use the tray(s) as a resource? choose all answers which apply. take order wash the mixer’s bowl and mix the dough bake the cookies cool the cookies accept payment 1 points question 3 determine the task time for the following tasks. fill integer numbers into the blank (e.g., 5 rather than 5.0) wash and mixing the dough: minute(s)/order spoon cookies onto the tray: minute(s)/order set up timer: minute(s)/order bake: minute(s)/order cool the cookies: minute(s)/order pack the cookies: minute(s)/order accept payment: minute(s)/order 2 points question 4 q4: determine the cycle time for the following resources. fill integer numbers into the blank (e.g., 5 rather than 5.0) kristen (you): minute(s) roommate: minute(s) oven: minute(s) 2 points question 5 what is the capacity rate (in orders/hour) of the roommate? 1 points question 6 what is the capacity rate (in orders/hour) of the whole process? 2 points question 7 how long (in minutes) it takes to process the first order?

If a hotel has 100 rooms, and each room takes 25 minutes to clean, how many housekeepers working 8-hour shifts does the hotel need at 50 percent occupancy?

Draw, label and explain the circular flow model (cfm). include the following: firms, households, product market, and factor (or resource) market.who owns the productive resources? what are those resources? what payment does each type of resource earn? explain the two markets in the cfm and explain the roles that firms and household each play in the cfm.