Pease do it on excel

Scenario 3:

Pennys Grocery has hired you and she needs to know the kilograms of bananas to have on hand each day.

Each kilogram of pears costs $2.40 and can be sold for $3.40. Unsold pears are worthless at the end of the day. The following demands were found after studying the last six month's sales:

100 kilograms of pears one-fourth of the time

150 kilograms of pears one-half of the time

175 kilograms of pears one-fourth of the time

Required:

Determine whether Jos Grocery should order 100, 150, or 175 kilograms of bananas.

You need to show your calculations, and in your report explain to Penny why you have determined the value that you have. Remember Penny is not an accountant.

Scenario 4:

General Hospital uses a job-costing system for all patients. In March, the Critical Care and Special Care facilities had cost allocation bases of 5,000 nursing days and 4,000 nursing days, respectively. The nursing care charges for each department for the month were $2,106,000 and $1,500,000, respectively. The General Care area had costs of $2,700,000 and 8,500 nursing days for the month.

Patient Jim Hansen spent 5 days in Critical Care, 4 days in Special Care, and 21 days in General Care in March.

Required:

a. Determine the cost allocation rate for each department.

b. What are the total charges to Mr. Hansen if he was in the facility the entire month of March?

c. Create a letter to Mr. Hansen outlining his bill in detail.