User Account

All Pages

What is the total coq as a percentage of total sales

Assignment Help Cost Accounting
Reference no: EM13876501

Spreadsheet Application Use the data and a spreadsheet to complete this prob- lem. Use the spreadsheet functions to carry out all calculations. Do not hard-code or carry out cal- culations elsewhere and type in the calculated amounts.

 

2010

2011

Sales

$15,000

$18,750

Materials inspection

300

60

Production inspection

160

125

Finished product inspection

225

70

Preventive  equipment maintenance

20

60

Scrap (net)

500

300

Warranty repairs

700

400

Product design engineering

150

270

Vendor certification

10

60

Direct costs of returned goods

250

80

Training of factory workers

40

140

Product  testing-equipment  maintenance

60

60

Product testing labor

210

90

Field repairs

70

30

Rework before shipment

240

180

Product-liability  settlement

360

60

Emergency repair and maintenance

190

60

1. Determine the information you'll need to generate cost-of-quality (COQ) report and set up a spread- sheet for this information. Among the items to be included in the COQ report are proper headings of the report, revenue and cost items (cost items should be in the cost-of-quality category), and cost as a percentage of revenues for each of the two years.

2. Input the data provided in 17-67 into the spreadsheet by COQ category.

3. Enter functions or steps to calculate the total amount for each COQ category and the total COQ. Do not hard-code or type in the amounts.

4. Enter functions or steps to calculate the total cost of each COQ category as a percentage of revenues for each of the years. Use two digits after the decimal point for the percentages. Do the same for the total COQ. Do not hard-code or type in the amounts.

5. Move to another area of the spreadsheet or use a fresh sheet and title the area "Cost of Quality Trend Analysis." Enter functions or steps for the percentages; do not hard-code or type in the amounts.

6. Create a bar chart to compare the percentages of each of the COQ categories and the total COQ in 2010 and 2011.

7. Do a sensitivity analysis by making the following changes to the 2011 amounts:

• Increase the total sales by 5 percent.

• Increase total prevention cost by 6 percent.

• Decrease total internal failure cost by 60 percent.

• Decrease total external failure cost by 50 percent.

Required: What is the total COQ as a percentage of total sales?

Reference no: EM13876501

Questions Cloud

Identify the main issue or problem outlined within the case : Read through the case, "Cow Wow Cereal Milk". In a brief paragraph, identify the main issue/problem outlined within the case. Identify the market segments/clusters presented and any other relevant segments not mentioned in the case
Write essay on diversity : In this essay, you will write about diversity. The purpose of this essay is to demonstrate how you have met the diversity outcome through your past coursework or work experiences
Prepare a spreadsheet that produces a cost-of-quality report : Prepare a spreadsheet that produces a cost-of-quality (COQ) report for both 2010 and 2011. Carry per- centage computations to two decimal places.
Discuss why jan williams has an ethical responsibility : Discuss why Jan Williams has an ethical responsibility to take some action in the matter of GroChem, Inc., and the dumping of toxic wastes.
What is the total coq as a percentage of total sales : What is the total COQ as a percentage of total sales? Create a bar chart to compare the percentages of each of the COQ categories and the total COQ in 2010 and 2011.
What is the foundation of morals : "It may be objected that many who are capable of the higher pleasures occasionally, under the influence of temptation, postpone them to the lower." To what is this an objection? What is Mill's response?
Evaluate an existing computer work station : This activity is designed to give you an opportunity to apply ergonomic principles to evaluate an existing computer work station. You may evaluate your own computer work station or that of a co-worker or friend
Erp framework and open source of erp software : Write a report of 8 to 10 pages on the topic of "Information Technology For Managers"Report must be in proper format along with title page and refrences.
Distributes various plumbing products used in homes : In Problem 9-45, Cain Components manufactures and distributes various plumbing products used in homes and other buildings.

Reviews

Write a Review

Cost Accounting Questions & Answers

  Changes in the amount of liquid assets

Calculate its days sales uncollected at the end of each year and evaluate and comment on any changes in the amount of liquid assets tied up in receivables.

  Computation of uncollectible-account expense

Explanations are not required. Prepare a T-account for Allowance for Uncollectible Accounts to show your computation of uncollectible-account expense for the year.

  Compute the earnings per share of common stock

Compute the earnings per share of common stock. It reports net income of $380,000 and a weighted-average of 200,000 shares of common stock outstanding for the year. Compute the earnings per share of common stock.

  Calculating payback

Calculating Payback. An investment project provides cash inflows of $585 per year for 8 years. What is the project payback period if the initial cost is $1,700? What if the initial cost is $3,300? What if it is $4,900?

  Compute mike singletary corporation return

Compute Mike Singletary Corporation's return on common stockholders' equity for 2010.

  What would be the money multiplier

What would be the money multiplier and the maximum amount of checkable deposits and what would be the money supply amount in this system after deposit expansion?

  You have been given the following information for ethan

you have been given the following information for ethan company as of june 1 2010. ethan company purchased a parcel of

  Journalize sundance co.

The cost of the merchandise returned was $2,850. Journalize Sundance Co.'s and Butter field Co.'s entries for the payment of the amount due.

  Estimates that total cash flows to be generated by selling

Customers  purchased your products throughout the year. Total sales for the year were $2,950,000. This cost of this inventory,  was $1,500,000 and you use a perpetual inventory system.

  Estimate the cost of the merchandise destroyed

The merchandise inventory was destroyed by fire on August 19. The following data were obtained from the accounting records.

  What were the actual costs in april

Using this information, prepare a budget for May stating the total amount for the May budget. Assume the budget will increase to 23,000 jars of sauce reflecting anticipated sales increase related to a new marketing campaign.

  What is the annual cash interest payment

What is the maturity value, what is the annual cash interest payment and what are the proceeds the company receives upon issuance of the bond?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd