1. Prepare a customer profitability analysis for Trace Telecom and Caltex Computer. (Hint: Refer to Exhibit 5-13 for guidance.) 2. Build a spreadsheet: Construct an Excel spreadsheet to solve requirement (1) above. Show how the solution will change if the following information changes: Trace Telecom's sales revenue was S185,000 and Caltex Computer's cost of goods sold was $59,000.
Q: The commercial (sales) of both firms is as follows: Company A Company B Sales 4,000,000 4,000,000…
A: The question is related to ratio analysis and the comparison between two companies is made on the…
Q: Nicholson Co sells mobile telephones. It supplies its customers with telephones and wireless…
A: V) Percentage of Customers Lost per annum = no. of. customers lost / average no. of. customers…
Q: Given the following data, compute the Survival Revenues (SR) for a corporation which sells Black &…
A: Survival revenue indicates the amount of revenue that a corporation requires to earn in order to…
Q: In response to how the sales incentives might be contributing to falling profits despite growing…
A: Answer a:
Q: Nicholson Co sells mobile telephones. It supplies its customers with telephones and wireless…
A: Ratio Analysis It is a technique by which the financial position of a company is analyzed. This…
Q: Refer to the original data, if the lunch and snack expenses increase by 20% due to increasing price…
A: Given in the question: The lunch and snack expenses has been increased by 20% MESRA Kids charge per…
Q: Can you explain to me why my teacher said that the answer in here can't be determined? Or was she…
A: This question is related to trading accounts of final accounts, in which we have given that net…
Q: The Food division of Garcia Company reports the following for the current year. Sales $ 4,270,000…
A: The income statement represents the net income or net loss calculated by deducting the expenses from…
Q: a. Denali Limited, a manufacturing company, had the following income statement information: Revenue…
A: Gross profit refers to the profit a company makes after the consideration of all the expenses…
Q: Q. Calculate Zahner’s 2017 contribution margin percentage, breakeven revenue, and degree of…
A: The contribution margin percentage using sales agent of 42% is computed by dividing the difference…
Q: Papa’s Pizza is the market leader and Pizza Prince is an up-and-coming player in the highly…
A: Ratio analysis: It is the financial analysis tool for measuring the profitability, liquidity,…
Q: Nicholson Co sells mobile telephones. It supplies its customers with telephones and wireless…
A: i) Return on capital employed =Profit before interest and taxAverage capital employed=$48…
Q: On the basis of the following data, the general manager of Foremost Footwear Inc. decided to…
A: Fixed expenses (Fixed costs and Fixed selling and admin. expenses) will not become 0 if Children…
Q: they produced 20,000 pieces of furniture were produced? 3. How does the format of the income…
A: 3.The difference between manufacturing income statement and merchandising income statement is due to…
Q: Use the high-low method to estimate the fixed and variable portions of store costs based on…
A: High-Low method is the method which is used by the company in order to know and calculate the fixed…
Q: Refer to the information for Petoskey Company from Exercise 8-44. Assume that 20% of theAlanson…
A: Contribution margin is the excess of sales revenue over variable costs in the business. Operating…
Q: Riley is interested in buying a local coffee shop and wants to determine its profitability…
A: Break-even point refers to a situation or level where the company covers all its fixed costs through…
Q: - On the basis of the following data, the general manager of Hawkeye Shoes Inc. decided to…
A: An income statement is one of several financial statements used to evaluate a company's financial…
Q: Located below is a sample from the income statement for Walkout Ltd. Sales revenue 200,000 (110,000)…
A: Break even in $ = Total Fixed Cost / Contribution Margin Ratio Break even in units = Total Fixed…
Q: Financial information for BDS Enterprises for the year-ended December 31, 20xx, was gathered from an…
A: Income Statement Profit margin, return on investment, and residual income
Q: How would overall corporate profits be affected if it sells 4,000 units to the Computer Division at…
A: Overall corporate profit increase (decrease) by = (Purchase price - Selling price to outside…
Q: The success of a business depends on many things. For example, you are the senior manager of the ABC…
A: Markup Markup is amount added to cost to recover overhead and gain profits. Markup is also generally…
Q: Megamart, a retailer of consumer goods, provides the following information on two of its departments…
A: Profit Margin = Net income / Sales Investment Turnover = Sales / Average Invested Assets
Q: A supply chain has the following information:(a). Compute the total supply chain throughput time for…
A: Total supply chain can be computed by adding inventory unit in all the entities in the supply chain.…
Q: Financial information for BDS Enterprises for the year-ended December 31, 20xx, was gathered from an…
A: working notes : $190,000-$119,700=$70,300 Less: Income tax expense (21% of pretax income…
Q: Veronica Mars, a recent graduate of Bell’s accounting program, evaluated the operating performance…
A: Note: In this question, Fixed costs are irrelevant cost in decision making because they will…
Q: Gail Johnston is the CFO of Lancet Technologies, a manufacturer of parts and supplies for the cable…
A: Income Statement PARTICULAR HARDWARE SUPPLIES TOTAL Sales $ 4,000,000 $ 3,000,000…
Q: Financial information for BDS Enterprises for the year-ended December 31, 20xx, was gathered from an…
A: Preparation of income statement helps the business entity in determining how much gross profit or…
Q: Thank you for that, it actually coincides with what I think. However, could you please calculate the…
A: Break even Level is the point of sales revenue where the company neither earns any profits nor…
Q: On the basis of the following data, the general manager of Foremost Footwear Inc. decided to…
A: If Children's Shoes are discontinued, there will be no variable cost because there would be no…
Q: You are a manager at Percolated Fiber, which is considering expanding its operations. Your boss said…
A: Depreciation is a non cash expenses. So this expense should be added back to calculate the free cash…
Q: Muhammad Raza company is a producer of pastries. The company hires an economist to determine the…
A: The demand mechanism states that if all other factors like income, likings, economical…
Q: South Coast Appliance Store is a small company that has hired you to perform some management…
A: Total variable cost = Cost of goods sold + Commissions Variable cost per unit sold = Total variable…
Q: Following are data for BioBeans and GreenKale, which sell organic produce and are of similar size.…
A:
Q: Media Mogul Inc. is a marketing company that offers a variety of marketing offerings to its…
A: New Revenue recognition model: There are five steps under revenue recognition principle Step 1:…
Q: Identify the activity ratio of a computer shop is its Cost of Goods Sold is P12 million and the…
A: Ratio Analysis: Ratio analysis is a process of determining the relationship between accounting…
Q: Media Mogul Inc. is a marketing company that offers a variety of marketing offerings to its…
A: The question is based on the concept of Business Transaction Analysis.
Q: The manager of the West store has concerns relating to the store’s financial performance and has…
A: Operating income (loss) = Gross profit - Total expenses Operating Income/(loss) % = Operating…
Q: Media Mogul Inc. is a marketing company that offers a variety of marketing offerings to its…
A: The entity will only include variable consideration only to the extent that it is probable that a…
Q: Dejounte Corp had a margin of safety of $108,503 last month, with sales revenue of $819,291 and…
A:
Q: Stylish Sitting is a retailer of office chairs located in San Francisco, California. Due to…
A: Surplus or deficit in the income statement is the excess or shortfall of operating income of the…
Q: Arrow is a chain of used car dealers with showrooms in Lincoln, Derby, and Sheffield and a separate…
A: The contribution margin is the difference between the selling price and the variable cost. In other…
Q: Financial information for BDS Enterprises for the year-ended December 31, 20xx, was gathered from an…
A: Income statement is the summary showing the revenues and costs in which the latter is subtracted…
Q: Complete this question by entering your answers in the tabs below. Reg 1 Req 2 Req 3 Reg 4 Reg 5 Req…
A: Given: The product will be sold to wholesalers in boxes of 24 tubes for $10 per box $96,000 charge…
Q: In 2007 Terry Brady, the legendary athlete from Indiana, decided to leave his job as head football…
A: Answer a) Total explicit cost =Cost of product and services sold + Selling expenses+ Administrative…
Q: One Manila Inc.'s president, Zane Cruz, is concerned about the prospects of one of the firm's major…
A: Profit=Selling Price-Cost Price
Q: Indicate in the following chart the most likely source of information for each business decision.…
A: Accounting information is the information related to the books of accounts of the company. It is…
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
- Problem 1. Mahinahon Company would like to institute an activity-based costing system to price products. The company's Purchasing Department incurs costs of P550,000 per year and has six employees. Purchasing has determined the three major activities that occur during the year. Activity Allocation Measure # of People Total Cost Issuing purchase orders # of purchase orders 1 P285,000 Reviewing receiving reports # of receiving reports 2 P190,000 Making phone calls # of phone calls 3 P220,000 During the year, 50,000 phone calls were made in the department; 15,000 purchase orders were issued; and 10,000 shipments were received. Product A required 200 phone calls, 150 receiving reports, and 50 purchase orders. Product B required 350 phone calls, 400 receiving reports, and 100 purchase orders. 1Determine the amount of purchasing department cost that should be assigned to each of these products. 1.2. Determine purchasing department cost per…Assume a company’s activity-based costing system includes three activities with the following activity rates: Activity Cost Pool Activity Rate Travel $ 2 per mile driven Deliveries $ 50 per delivery Customer service $ 22 per phone call Two of the company’s many customers include Customer A and Customer B. These two customers consumed the company’s activities as follows: Total Expected Activity Customer A Customer B Travel (number of miles driven) 340 250 Deliveries (number of deliveries) 15 5 Customer service (number of phone calls) 20 12 How much cost would be assigned from the Travel activity to Customer A?Assume a company's activity-based costing system includes three activities with the following activity rates: Activity Cost Pool Activity Rate Travel $ 2 per mile driven Deliveries $ 50 per delivery Customer service $ 22 per phone call Two of the company's many customers include Customer A and Customer B. These two customers consumed the company's activities as follows: Total Expected Activity Customer A Customer B Travel (number of miles driven) 300 250 Deliveries (number of deliveries) 15 5 Customer service (number of phone calls) 20 12 If the company earned $1,130 in revenue serving Customer B, then what is the customer margin for this customer? Multiple Choice $96 $156 $116 $136
- Exercise 7-7 (Static) First-Stage Allocations [LO7-2] The operations vice president of Security Home Bank has been interested in investigating the efficiency of the bank's operations. She has been particularly concerned about the costs of handling routine transactions at the bank and would like to compare these costs at the bank's various branches. If the branches with the most efficient operations can be identified, their methods can be studied and then replicated elsewhere. While the bank maintains meticulous records of wages and other costs, there has been no attempt thus far to show how those costs are related to the various services provided by the bank. The operations vice president has asked your help in conducting an activity-based costing study of bank operations. In particular, she would like to know the cost of opening an account, the cost of processing deposits and withdrawals, and the cost of processing other customer transactions. The Westfield branch of Security Home…Evaluating Selected Cost Driver Assume that a manufacturer of specialized machine parts developed the following total cost estimating equation for manufacturing costs. Y = $14,400 + $1,250 (actual units) a. What is total estimated manufacturing costs if 180 units are produced? $Answer 0Activity-based costing in an insurance company Umbrella Insurance Company carries three major lines of insurance: auto, workers' compensation, and homeowners. The company has prepared the following report for 20Y2: Management is concerned that the administrative expenses may make some of the insurance lines unprofitable. However, the administrative expenses have not been allocated to the insurance lines. The controller has suggested that the administrative expenses could be assigned to the insurance lines using activity-based costing. The administrative expenses are comprised of five activities. The activities and their rates are as follows: Activity-base usage data for each line of insurance were retrieved from the corporate records and are shown below. a.Complete the product profitability report through the administrative activities. b.Determine the underwriting income as a percent of premium revenue. C.Determine the Operating income as a percent of premium revenue, rounded to one decimal place. d.Interpret the report.
- Cost of quality and value-added/non-value-added reports for a service company A. Using the information in Exercise 17, identify the cost of quality classification for each activity and whether the activity is value-added or non-value-added. B. Prepare a cost of quality report. Assume that sales are 3,000,000. (Round percentages to one decimal place.) C. Prepare a value-added/non-value-added analysis. D. Interpret the information in (B) and (C).Wrappers Tape makes two products: Simple and Removable. It estimates it will produce 369,991 units of Simple and 146,100 of Removable, and the overhead for each of its cost pools is as follows: It has also estimated the activities for each cost driver as follows: Â How much is the overhead allocated to each unit of Simple and Removable?Assume a company's activity-based costing system Includes three activities. The following Information is avallable with respect to those activitles: Estimated Overhead Activity Cost Pol Travel Cost Expected Activity $ 150,000 $ 110,000 $ 220,000 100.000 miles driven Deliverles 2,200 customer deliverles Customer service 10,000 phone calls What is the activity rate for the Travel activity? Multiple Choice $1.50 per mile driven $15.00 per mile driven $0.15 per mile driven $1.15 per mile driven
- Please Answer part 4. Part 1-3 answers Part 1 Computation of Cost Allocation Rate for each activity: Activity Costs Base usage Allocation rate Material Handling 160,000 20,000 8 Packaging 390,000 2,000 195 Quality Assurance 112,000 1,600 70 Total 662,000 Part 2 Activity Usage of All Activities: Activity Commercial Travel Total Material Handling 8700 4450 13,150 Packaging 900 300 1,200 Quality Assurance 270 370 640 Allocation of Cost basis Usage: Activity Commercial Travel Material Handling 69,600 35600 (Activity Usage * Cost Allocation Rate) (8,700 * 8) (4450 * 8) Packaging 175,500 58500 Quality Assurance 18,900 25900 Total 264,000 120000 Units Produced 3,000 20000 Cost Per Unit 88 6 Part 3 Particulars Commercial Travel Usage of…Assume a service company has implemented an activity-based costing system with five activities as shown below: Activity Cost Pool (Activity Measure) Customer deliveries (Number of deliveries) Manual order processing (Number of manual orders) Electronic order processing (Number of electronic orders) Line item picking (Number of line items picked) Other organization-sustaining costs (None) Total Cost Total Activity $ 400,000 $ 280,000 $ 150,000 $ 450,000 $ 300,000 8,000 deliveries 5,000 manual orders 15,000 electronic orders 375,000 line items The company serves numerous customers, two of which include Hospital A and Hospital B. The activity demands pertaining to these two customers are as follows: Activity Hospital A Hospital B Activity Measure Number of deliveries Number of manual orders Number of electronic orders Number of line items picked 8. 25 30 15 0. 115 250 How much total activity cost should be assigned to Hospital A for internal management purposes? Multiple Choice $785 <…Required information Exercise 9-35 and 9-36 (Algo) Skip to question The Personnel Department at Hernandez Bros. is centralized and provides services to the two operating units: Miami and New York. The Miami unit is the original unit of the company and is well established. The New York unit is new, much like a start-up company. The costs of the Personnel Department are allocated to each unit based on the number of employees in order to determine unit profitability. The current rate is $620 per employee. Data for the fiscal year just ended show the following. Miami New York Number of employees 1,320 420 Number of new hires 12 32 Number of employees departing 18 18 Exercise 9-35 (Algo) Unitwide versus Department Allocation-Administrative (Service) Function (LO 9-2, 3) Required: a. Compute the cost allocated to each unit using the current allocation system. b. Livan, the manager of the Miami unit, is unhappy with the allocation from Personnel. He…