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 1
Answer 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 1
M1-19. Classifying Cost Drivers
Classify 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 Behavior
For 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 unit
b. Total fixed costs
c. Total mixed costs
d. Average fixed costs per unit
e. Total current manufacturing costs
f. Average variable costs
g. Total costs when employees are paid $15 per hour for the first 40 hours worked each week and $20
for each additional hour
h. Total costs when employees are paid $15 per hour and guaranteed a minimum weekly wage of $300
i. Total costs per day when a consultant is paid $200 per hour with a maximum daily fee of $1,000.
j. Total variable costs
k. Total costs for salaries of social workers where each social worker can handle a maximum of 25 cases
l. A water bill where a flat fee of $800 is charged for the first 100,000 gallons and additional water costs $0.005 per gallon
m. Total variable costs properly used to estimate step costs
n. Total materials costs
o. Rent on exhibit space at a convention
E2-19. Scatter Diagrams and High-Low Cost Estimation
Assume 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)
a. 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 Estimation
Assume a Potbelly’s restaurant has the following information available regarding costs at representative levels of monthly sales: (PLEASE SEE ATTACHMENT E2-21 TO ANSWER THIS)
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more