Cranshaw Business Services (CBS) operates an information technology (IT) consulting firm out of two offices: Detroit and Los Angeles. Corporate services, such as legal, finance, and personnel, are centralized at the main office and the costs of these services are allocated to the two offices for the purposes of profitability assessment. The Detroit office is the original unit of the company and is well established, having long-time clients from the automotive and other manufacturing industries. The Los Angeles office is new with a smaller, much more varied, clientele. The costs of personnel services at CBS are currently allocated on the basis of the number of employees in each office. The annual costs of the personnel department total $460,000. Data for the fiscal year just ended show the following: Number of employees Number of new hires Number of employees departing Allocation based on Employees Transitiona Exercise 9-32 (Algo) Unitwide versus Department Allocation-Decision Making (LO 9-1, 2, 3) The manager of the Los Angeles office is now unhappy with the results of the controller's study. The manager asks the controller to develop separate rates for fixed and variable costs in the Personnel Department. The controller reports back to the Los Angeles manager that the costs would be as follows: Variable Cost $102,000 93,000 Detriot Los Angeles Detroit Los Angeles 358 142 17 13 9 Total Allocated Cost Fixed Cont $ 142,000 123,000 Required: a. The manager claims that the Los Angeles office should only be allocated the variable costs from this system, because the company would have to pay the fixed costs even if the Los Angeles office did not exist. Compute the cost allocated to each unit using the approach the Los Angeles manager prefers. Total Cost $244,000 216,000

I need answer typing clear urjent no chatgpt used i will give upvotes

Required information [The following information applies to the questions displayed below.] Consider the following narrative describing the process of filling a customer's order at a Starbucks branch: Identify the start and end events and the activities in the following narrative, and then draw the business process model using BPMN: the Starbucks customer entered the drive-through lane and stopped to review the menu. He then ordered a Venti coffee of the day and a blueberry muffin from the barista. The barista recorded the order in the cash register. While the customer drove to the window, the barista filled a Venti cup with coffee, put a lid on it, and retrieved the muffin from the pastry case and placed it in a bag. The barista handed the bag with the muffin and the hot coffee to the customer. The customer has an option to pay with cash, credit card, or Starbucks gift card. The customer paid with a gift card. The barista recorded the payment and returned the card along with the…

how do you calculat mpg in excel?

All blanks need to be filled please and thank you, it's incomplete as of now.

Is there an excel table showing how to use functions?

How do you make a two-dimensional columnar chart in excel?

Does a user view always require multiple tables to support it? Explain.

How do you access the Power Query interface?