Carescript Data (next tab) -- contains all data available to us to help Carescript management. We want to organize it visually. What's so special about data visualization? As we will discover, having the ability to look at data in a dynamic way is critical to picking up on trends and possible outliers. Further, it will help Carescript management make a labor cost prediction. Part 1 -- Build the following scatter graphs on their own tabs and label as Scatter #1, Scatter #2, and Scatter # 3. Each scatter should have a title, and axes labels. Scatter #1: Labor cost over time Scatter #2: Labor cost by prescription volume with trend line and line equation. Scatter #3: Labor cost per prescription over time. Part 2 -- Using the "Text Box" in the "Insert" ribbon, add a few sentences annotating the scatter from above. Describe any trends, holes in the data, or observations. Remember that your audience may not be familiar with cost visualization.

Carescript Data (next tab) -- contains all data available to us to help Carescript management. We want to organize it visually. What's so special about data visualization? As we will discover, having the ability to look at data in a dynamic way is critical to picking up on trends and possible outliers. Further, it will help Carescript management make a labor cost prediction. Part 1 -- Build the following scatter graphs on their own tabs and label as Scatter #1, Scatter #2, and Scatter # 3. Each scatter should have a title, and axes labels. Scatter #1: Labor cost over time Scatter #2: Labor cost by prescription volume with trend line and line equation. Scatter #3: Labor cost per prescription over time. Part 2 -- Using the "Text Box" in the "Insert" ribbon, add a few sentences annotating the scatter from above. Describe any trends, holes in the data, or observations. Remember that your audience may not be familiar with cost visualization.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter3: Cost Behavior

Section: Chapter Questions

Problem 39P: Randy Harris, controller, has been given the charge to implement an advanced cost management system....

See similar textbooks

Similar questions

Data Master is a computer software consulting company. Its three major functional areas are computer programming, information systems consulting, and software training. Cynthia Moore, a pricing analyst in the Accounting Department, has been asked to develop total costs for the functional areas. These costs will be used as a guide in pricing a new contract. In computing these costs, Moore is considering three different methods of allocating overhead costs-the direct method, the step method, and the reciprocal method. Moore assembled the following data on overhead from its two service departments, the Information Systems Department and the Facilities Department. Service Departments User Departments Info Systems Facilities Computer Program Consult Training Total Budgeted Overhead $ 50,000 $ 25,000 $ 75,000 $ 110,000 $ 85,000 $ 345,000 Info Systems (hrs.) 400 1,100 600 900 3,000 Facilities (Square feet) 200,000…
Auflegger, Inc., manufactures a product that experiences the following activities (and times): Required: 1. Compute the MCE for this product. 2. A study lists the following root causes of the inefficiencies: poor quality components from suppliers, lack of skilled workers, and plant layout. Suggest a possible cost reduction strategy, expressed as a series of if-then statements that will reduce MCE and lower costs. Finally, prepare a strategy map that illustrates the causal paths. In preparing the map, use only three perspectives: learning and growth, process, and financial. 3. Is MCE a lag or a lead measure? If and when MCE acts as a lag measure, what lead measures would affect it?
Randy Harris, controller, has been given the charge to implement an advanced cost management system. As part of this process, he needs to identify activity drivers for the activities of the firm. During the past four months, Randy has spent considerable effort identifying activities, their associated costs, and possible drivers for the activities costs. Initially, Randy made his selections based on his own judgment using his experience and input from employees who perform the activities. Later, he used regression analysis to confirm his judgment. Randy prefers to use one driver per activity, provided that an R2 of at least 80 percent can be produced. Otherwise, multiple drivers will be used, based on evidence provided by multiple regression analysis. For example, the activity of inspecting finished goods produced an R2 of less than 80 percent for any single activity driver. Randy believes, however, that a satisfactory cost formula can be developed using two activity drivers: the number of batches and the number of inspection hours. Data collected for a 14-month period are as follows: Required: 1. Calculate the cost formula for inspection costs using the two drivers, inspection hours and number of batches. Are both activity drivers useful? What does the R2 indicate about the formula? 2. Using the formula developed in Requirement 1, calculate the inspection cost when 300 inspection hours are used and 30 batches are produced. Prepare a 90 percent confidence interval for this prediction.
Please what is the solution to the cost operation management picture I uploaded. Thanks
Quality control reports in graphic form: (Check all that apply.): Multiple select question. include pie charts and bar graphs. help to clarify trends in data. are used in place of quality cost reports in numeric form. stack appraisal costs on top of prevention costs.
JPL, Inc. has provided its sales and expense data for the most recent period. The Controller has asked you prepare a spreadsheet that shows the related CVP Analysis computations. Use the information included in the Excel Simulation and the Excel functions described below to complete the task.
a) You are developing schedule estimates (and costs). Why should you document assumptions and not just show the generated baseline schedule and budget alone? b) Someone suggest you build your WBS by going to each functional department and meeting with a representative to get their take on required work packages, precedencies, and durations. Why might you decline to follow this advice if you want to have a successful project? c) You have recently been promoted to the position of project manager at your company. Your team consist of senior members of the technical staff, and it is time to set up the team operating rules. You expect some resistance because they see you as “wet behind the ears.” How would you go about doing this?
Please I want you to help me solve that cost operation management question I uploaded. Thanks
to create a model for a production cost report using the weighted average method for the month of May. Following good Excel design techniques, you should have an input area in which you put the department information for the month, and an output area that calculates the production cost report. As always, you should have only formulas or references in your output area. You should also include directions (in a text box) for users. After completion of the production cost report using the weighted average method, create a new worksheet and label the tab “FIFO”. Create a production cost report using the same information using the FIFO method. Spartans Bakery has two department: mixing and baking. All products start in the Mixing Department, where materials are added and conversion costs (labor, overhead) are incurred. Once the product is “finished” with regards to the Mixing, it moves to the Baking Department where additional conversion costs are incurred before moving to Finished…
Data Performance, a computer software consulting company, has three major functional areas: computer programming, information systems consulting, and software training. Carol Bingham, a pricing analyst, has been asked to develop total costs for the functional areas. These costs will be used as a guide in pricing a new contract. In computing these costs, Carol is considering three different methods of the departmental allocation approach to allocate overhead costs: the direct method, the step method, and the reciprocal method. She assembled the following data from the two service departments, information systems and facilities: Service Departments Production Departments Information Systems Facilities Computer Programming Information Systems Consulting Software Training Total Budgeted overhead (base) $ 368,000 $ 184,000 $ 736,000 $ 874,000 $ 575,000 $ 2,737,000 Information Systems (computer hours) 600 1,200 300 900 3,000 Facilities (square feet) 240 960 600 600…
Can any accountant show me the basic and simple cost analysis of a product (for ex: a watch) in excel or google sheet? please include any cost that we need to consider
Determine Question Sequence (A list of questions with the sequence of customer priority) with scale 1-5 (customer priority) for new smartpen product design