A quality control activity analysis indicated the following four activity costs of a hotel: Inspecting cleanliness of rooms Processing lost customer reservations Reworking incorrectly prepared room service meals Employee training Total Sales are $4,700,000. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Prepare a cost of quality report. Round the percents of total quality cost to the nearest whole number and the percents of total sales to one decimal place. Cost of Quality Report Quality Cost Classification Prevention Appraisal Internal failure External failure Total $155,100 310,200 232,650 77,550 $775,500 Quality Cost Percent of Total Quality Cost % % % Percent of Total Sales % 364

A quality control activity analysis indicated the following four activity costs of a hotel: Inspecting cleanliness of rooms Processing lost customer reservations Reworking incorrectly prepared room service meals Employee training Total Sales are $4,700,000. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Prepare a cost of quality report. Round the percents of total quality cost to the nearest whole number and the percents of total sales to one decimal place. Cost of Quality Report Quality Cost Classification Prevention Appraisal Internal failure External failure Total $155,100 310,200 232,650 77,550 $775,500 Quality Cost Percent of Total Quality Cost % % % Percent of Total Sales % 364

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter23: Flexible Budgeting (flexbud)

Section: Chapter Questions

Problem 6R

See similar textbooks

Similar questions

A quality control activity analysis indicated the following four activity costs of a hotel: Inspecting cleanliness of rooms $181,350 Processing lost customer reservations 60,450 Rework incorrectly prepared room service meal 241,800 Employee training 120,900 Total $604,500 Sales are $3,100,000. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below. Open spreadsheet Prepare a cost of quality report. Round the percents of total quality cost to the nearest whole number and the percents of total sales to one decimal place. Cost of Quality Report Quality Cost Classification Quality Cost Percent of Total Quality Cost Percent of Total Sales Prevention $ % % Appraisal % % Internal failure % % External failure % % Total $ % %
When a company has post-acquisition expenditures related to Property, Plant, and Equipment it must determine whether the amount should be expensed as an ordinary repair or capitalized as a major repair, addition, or betterment. This requires considering the nature of the expenditure and the use of judgment. Many companies use a threshold amount. Any expenditure below the threshold is expensed. Items over the threshold are examined and a decision is made about whether to expense or capitalize the item. This approach is justified by both materiality and considering costs and benefits. For example, a company with $94 million in net property, plant, and equipment and $250 million of operating expenses would not consider a $100 repair as material. Plus, if the company had to spend thousands of dollars examining every repair expenditure, the costs of doing the analysis could easily outweigh the benefits. SouthEast Equipment has a large number of machines and equipment that are available for…
Match each of the following cost items with the value chain business function where you would expect the cost to be incurred: Cost Item 1. Labor time to repair products under warranty 2. Radio commercials 3. Labor costs of delivering customer orders 4. Testing of competitor's product 5. Direct manufacturing labor costs 6. Development of order tracking system for online sales 7. Design cost of new product brochures 8. Hours spent designing childproof bottles 9. Training costs for representatives to staff the customer call center 10. Installation of robotics equipment in manufacturing plant Business Function
Regression, activity-based costing, choosing cost drivers. Sleep Late, a large hotel chain, has been using activity-based costing to determine the cost of a night’s stay at their hotels. One of the activities, “Inspection,” occurs after a customer has checked out of a hotel room. Sleep Late inspects every 10th room and has been using “number of rooms inspected” as the cost driver for inspection costs. A signicant component of inspection costs is the cost of the supplies used in each inspection.
The Excel worksheet form that appears below is to be used to recreate the Review Problem pertaining to the Magnetic Imaging Division of Medical Diagnostics, Inc. Download the workbook containing this form from Connect, where you will also receive instructions about how to use this worksheet form. You should proceed to the requirements below only after completing your worksheet. Required: 1. Check your worksheet by changing the average operating assets in cell B6 to $8,000,000. The ROI should now be 38% arid the residual income should now be $1,000,000. If you do not get these answers, find the errors in your worksheet and correct them. Explain why the ROI and the residual income both increase when the average operating assets decrease. 2. Revise the data in your worksheet as follows: a. What is the ROI? b. What is the residual income? c. Explain the relationship between the ROI and the residual income?
Assume you are the manager for the semi-trucks division at the Speedy Delivery Company. The semi-truck division is a cost center and you are reviewing the driver overtime costs for the previous year, shown here: A. Microsoft Excel or another spreadsheet application, create a line chart with markers showing the driver overtime expense. Describe your observations. B. Knowing that safety is important in your industry and weather plays a significant role in the safety of drivers, you decide to talk with the safety manager and obtained the following information: Using Microsoft Excel or another spreadsheet application, create individual line charts with markers showing the average snowfall and non-company highway accidents. Describe your observations and actions you might consider.
Convert the accompanying database to an Excel table to find: a.The total cost of all orders. b.Thetotal quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve. Question content area bottom Part 1 a. The total cost of all orders is $?????? enter your response here.
ctivity-Based Costing for a Service Business Sterling Hotel uses activity-based costing to determine the cost of servicing customers. There are three activity pools: guest check-in, room cleaning, and meal service. The activity rates associated with each activity pool are $8 per guest check-in, $25 per room cleaning, and $4 per served meal (not including food). Ginny Campbell visited the hotel for a three-night stay. Campbell had three meals in the hotel during her visit. Determine the total activity-based cost for Campbell's visit.
Pareto chart and cost of quality report for a service company The administrator of Liberty Hospital has been asked to perform an activity analysis of the emergency room (ER). The ER activities include cost of quality and other patient care activities. The lab tests and transportation are hospital services external to the ER for determining external failure costs. The result of the activity analysis is summarized as follows: Activities Activity Cost Patient registration $ 6,500 Verifying patient information 9,700 Assigning patients 13,000 Searching/waiting for doctor 9,200 Doctor exam 4,900 Waiting for transport 17,500 Transporting patients 16,200 Verifying lab orders 14,500 Searching for equipment 8,200 Incorrect labs 11,300 Lab tests 17,000 Counting supplies 19,000 Looking for supplies 8,200 Staff training 4,800 Total $160,000 a. b. c. d. Classify the…
A partial list of The Grand Hotel’s costs follows:a. Cost to mail a customer surveyb. Wages of convention setup employeesc. Pay-per-view movie rental costs (in rooms)d. Cost of foode. Cost of room mini-bar suppliesf. Training for hotel restaurant serversg. Cost to paint lobbyh. Cost of laundering towels and beddingi. Champagne for guestsj. Salary of the hotel managerk. Depreciation of the hotell. Cost of valet parkingm. Wages of bellhopsn. Cost to replace lobby furnitureo. Cost of advertising in local newspaperp. Wages of desk clerksq. Wages of maidsr. Cost of new carpetings. Guest room telephone costs for longdistance callst. Cost of soaps and shampoos for roomsu. Utility costv. Wages of kitchen employeesw. General maintenance suppliesInstructions1. What would be The Grand Hotel’s most logical definition for the final cost object?Explain.2. Identify whether each of the costs is to be classified as direct or indirect. For purposes of classifying each cost as direct or indirect, use the…
Long lines of patients wait for CAT scanning service in a hospital. Patients arrive for scans at a rate of 1.9 per hour. The average processing time for CAT service is 27 minutes per patient. Your summer internship is in the hospital where you are assigned to help analyze the bottleneck situation. One tool that you think can help evaluate the situation is a single server queueing model. Use the Single Server Queue Excel template to answer the following questions. Do not round intermediate calculations. Round your answers to three decimal places. What is the probability that the system is empty? What is the probability that a customer must wait for service? What is the average number of customers waiting for service in the queue? customer(s) What is the average wait time in the queue? hour(s) What is the average time spent in the system? hour(s)
Meagher Solutions Inc. manufactures memory chips for personal computers. An activity analysis was conducted, and the following activity costs were identified with the manufacture and sale of memory chips: a. Identify the cost of quality classification for each activity. Quality Activities Correct shipment errors Disposing of scrap Emergency equipment maintenance Employee training Final inspection Inspecting incoming materials Preventive equipment maintenance Processing customer returns Scrap reporting Supplier development Warranty claims. Total Quality Cost Classification Prevention b. Prepare a cost of quality report. Assume that the sales for the period were $4,000,000. If required, round percents to one decimal place. Activity Cost Appraisal Internal failure External failure Total $150,000 95,000 125,000 50,000 80,000 60,000 40,000 90,000 45,000 15,000 250,000 $1,000,000 Meagher Solutions Inc. Cost of Quality Report Percent of Total Quality Cost Quality Cost % % % % Quality Cost…