Casey wants to calculate the monthly payments for each loan option that he is considering. Switch to the Loan Options worksheet. In cell B12, create a formula using the PMT function to calculate the monthly payments for loan Option A. Use the values in cells B8, B10, and B5 for the Rate, Nper, and Pv arguments, respectively, and do not enter any values for the optional arguments. Copy the formula you created in cell B12 into the range C12:D12.

Gino's restaurant is a popular restaurant in boston, massachusetts. the owner of the restaurant has been trying to better understand costs at the restaurant and has hired a student intern to conduct an activity-based costing study. the intern, in consultation with the owner, identified the following major activities: activity cost pool activity measure serving a party of diners number of parties served serving a diner number of diners served serving drinks number of drinks ordered some costs, such as the cost of cleaning the linens that cover the restaurant's tables, vary with the number of parties served. other costs, such as washing plates and glasses, depends on the number of diners served or the number of drinks served. data concerning these activities are shown below. serving a party serving a dinner serving drinks total total cost $47,600 $153,000 $59,800 $260,400 total activity 7,000 parties 30,000 diners 46,000 drinks prior to the activity-based costing study, the owner knew very little about the costs of the restaurant. she knew that the total cost for the month was $260,400 and that 30,000 diners had been served. therefore, the average cost per diner was $8.68.required: 1. compute the activity rates for each of the three activities 2. according to the activity-based costing system, what is the total cost of serving each of the following parties of diners? a. a party of four diners who ordered three drinks in total b. a party of two diners who do not order any drinks c. a lone diner who orders two drinks 3. convert the total costs you computed in part (1) above to costs per diner. in other words, what is the average cost per diner for serving each of the following parties: a. a party of four diners who order three drinks in total b. a party of two diner who do not order any drinks c. a lone diner who orders two drinks 4. why do the costs per diner for the three different parties differ from each other and from the overall average coast of $9.80 per diner?

Nichols inc. manufactures remote controls. currently the company uses a plantminuswide rate for allocating manufacturing overhead. the plant manager is considering switchingminusover to abc costing system and has asked the accounting department to identify the primary production activities and their cost drivers which are as follows: activities cost driver allocation rate material handling number of parts $5 per part assembly labor hours $20 per hour inspection time at inspection station $10 per minute the current traditional cost method allocates overhead based on direct manufacturing labor hours using a rate of $20 per labor hour. what are the indirect manufacturing costs per remote control assuming an method is used and a batch of 10 remote controls are produced? the batch requires 100 parts, 5 direct manufacturing labor hours, and 3 minutes of inspection time.

Six years ago, an 80-kw diesel electric set cost $160,000. the cost index for this class of equipment six years ago was 187 and is now 194. the cost-capacity factor is 0.6. the plant engineering staff is considering a 120-kw unit of the same general design to power a small isolated plant. assume we want to add a precompressor, which (when isolated and estimated separately) currently costs $13291. determine the total cost of the 120-kw unit. (hint: skip $ and comma symbols)