Health Sciences homework help
Health Sciences homework help. Before accepting this assignment, PLEASE READ THE ASSIGNMENT IN FULL. THIS IS A VERY DETAILED ASSIGNMENT AND YOU MUST HAVE EXCEL!!! EXCEL IS A MUST, SPREADSHEETS ARE NEEDED FOR THE ASSIGNMENT!IF YOU CANT DO THIS PROPERLY WITHOUT USING SOMEBODY ELSES WORK, DO NOT ACCEPT THE ASSIGNMENT. ALSO, YOU NEED TO HAVE A VERY STRONG UNDERSTANDING OF THE ENGLISH LANGUAGE.ASSIGNMENT IS DUE BY 3/29/2018 at 5pm. This assignment requires two files to be uploaded, one Excel file and one Word Doc file. Answer question M1-19 from Chapter 1Answer questions M2-13, E2-19 (part a only) and E2-21 from Chapter 2 You must submit your work in Excel for all number problems. Use Word for narrative questions. If you use a Mac program, please save your file in a Windows-compatible form before submission. ON EXCEL – M1-19 from Chapter 1M1-19. Classifying Cost DriversClassify each of the following as structural, organizational, or activity cost drivers.a. Apple Inc. reorganizes production facilities from a layout in which all similar types of machines are grouped together to a layout in which a set of machines is designated for the production of a particular product and that set of machines is grouped together.b. A cable television company decides to start offering telephone service.c. IBM decides to stop making personal computers.d. Canon decides to start making high-volume photocopy equipment to compete head-to-head with Xerox.e. The number of meals a cafeteria serves.f. The number of miles a taxi is driven.g. A company eliminates the position of supervisor and has each work group elect a team leader.h. Tesla empowers employees to halt production if a quality problem is identified.i. The number of tons of grain a ship loads.j. Northbrook Mall decides to build space for 80 additional store.M2-13. Classifying Cost BehaviorFor each of the following situations, select the most appropriate cost behavior pattern (as shown in the illustrations following this problem) where the lines represent the cost behavior pattern, the vertical axis represents costs, the horizontal axis represents total volume, and the dots represent actual costs. Each pattern may be used more than once.a. Variable costs per unitb. Total fixed costsc. Total mixed costsd. Average fixed costs per unite. Total current manufacturing costsf. Average variable costsg. Total costs when employees are paid $15 per hour for the first 40 hours worked each week and $20for each additional hourh. Total costs when employees are paid $15 per hour and guaranteed a minimum weekly wage of $300i. Total costs per day when a consultant is paid $200 per hour with a maximum daily fee of $1,000. j. Total variable costsk. Total costs for salaries of social workers where each social worker can handle a maximum of 25 casesl. A water bill where a flat fee of $800 is charged for the first 100,000 gallons and additional water costs $0.005 per gallonm. Total variable costs properly used to estimate step costsn. Total materials costso. Rent on exhibit space at a conventionE2-19. Scatter Diagrams and High-Low Cost EstimationAssume the local Pearle Vision has the following information on the number of sales orders received and order-processing costs. (PLEASE SEE ATTACHMENT E2-19 TO ANSWER THIS)Requireda. Use information from the high- and low-volume months to develop a cost-estimating equation for monthly order-processing costs.E2-21. Cost Behavior Analysis in a Restaurant: High-Low Cost EstimationAssume a Potbellys restaurant has the following information available regarding costs at representative levels of monthly sales: (PLEASE SEE ATTACHMENT E2-21 TO ANSWER THIS)