Fitzgerald Supermarkets (FS) operates at capacity and decides to apply ABC analysis to three product lines: baked goods, milk and fruit juice, and frozen foods. It identifies four activities their activity cost rates as follows:Ordering $95 per purchase order
Delivery and receipt of merchandise $76 per delivery
Shelf-stocking $19 per hour
Customer support and assistance $0.15 per item sold
The revenues, cost of goods sold, store support costs, activities that account for the store support costs, and activity-area usage of the three product lines are as follows:

Baked Goods Milk and Fruit Juice Frozen Products
Financial data
Revenues $60,000 $66,500 $50,500
Cost of goods sold $41,000 $51,000 $32,000
Store support $12,300 $15,300 $9,600
Activity-area usage (cost-allocation base)
Ordering (purchase orders) 44 24 14
Delivery (deliveries) 120 60 36
Shelf-stocking (hours) 170 150 20
Customer support (items sold) 15,400 20,200 7,960
Under its simple costing system, FS allocated support costs to products at the rate of 30% of the cost of goods sold.

Required:

1. Use the simple costing system to prepare a product-line profitability report for FS.

2. Use the ABC system to prepare a product-line profitability report for FS.

3. What new insights does the ABC system in requirement 2 provide to FS managers?

Answers

Answer 1
Answer:

Answer:(1) Baked Goods profit $6,700, Milk and Fruit juice profit $200, Frozen Products profit $8,900 (2) Baked Goods profit $160, Milk and Fruit juice profit $2,870, Frozen Products Profit $12,860. (3) it provide insight to FS managers that Frozen Products is the most profitable among the three product lines.

Explanation:

(1) Baked Goods. Milk and Fruit juice. Frozen Products

$ $ $

Revenue. 60,000. 66,500. 50,500

Less : Cost of good sold 41,000. 51,000. 32,000

------------- -------------- ---------------

Gross Margin. 19,000. 15,500. 18,500

Less: Store Support. 12,300. 15,300. 9,600

----------- ------------ -------------

Profit. 6,700. 200. 8,900

------------- --------------- ----------------'

(2)

Baked Goods. Milk and Fruit juice. Frozen Products

$ $ $

Revenue. 60,000. 66,500. 50,500

Less Cost of good sold 41,000. 51,000. 32,000

------------- ---------------- -----------

Contribution. 19,000. 15,500. 18,500

Less Overhead

Ordering cost. 4,180. 2,280. 1,,330

Delivery&Receipt. 9,120. 4,560. 2,736

Shelf Stocking. 3,230. 2,850. 380

Customer Support & Assistant 2,310. 3,030. 1,194

------------ -------------- ------------

Profit. 160. 2,870. 12,860

------------------ ----------------- ---------------

(3) The new insight to FS managers is that Frozen Products is the most profitable among the three products lines

Workings

Ordering cost ($95 × 44) = 4,180 ($95 × 24) = 2,280 ($95 × 14) = 1,330

Delivery &Receipt ($76 × 120) = 9,120 ($76 × 60) = 4,560 ($76 × 36) = 2,736

Shelf Stocking ($19 × 170) = 3,230 ($19 × 150) = 2,850 ( $19 × 20) = 380

Customer Support &Assistant ($0.15 × 15,400) = 2,310 ($0.15 × 20,200) = 3,030 ($0.15 × 7,960)= 1,194

Answer 2
Answer:

Final answer:

To prepare a product-line profitability report for FS, first, use the simple costing system by allocating support costs to products at a rate of 30% of the cost of goods sold. Second, use the ABC system by calculating the total activity cost for each product line and allocating it based on activity-area usage. The ABC system provides more insights into cost drivers and helps in analyzing profitability.

Explanation:

1. Simple costing system:

Under the simple costing system, FS allocates support costs to products at a rate of 30% of the cost of goods sold. To prepare a product-line profitability report, we need to calculate the support costs allocated to each product line by multiplying their respective cost of goods sold by 30%. Then, subtract the allocated support costs from the revenues to determine the profitability.

2. ABC costing system:

Under the ABC costing system, we need to calculate the total activity cost for each product line by multiplying the activity cost rate with the respective activity-area usage. Then, allocate the total activity costs to each product line based on their activity-area usage. Finally, subtract the allocated support costs from the revenues to determine the profitability.

3. New insights from ABC system:

The ABC system provides a more accurate and detailed view of the costs associated with each product line. It allows FS managers to identify the activities that contribute the most to the total support costs and analyze the profitability of each product line based on these cost drivers. This insight helps in making informed decisions regarding product line management and pricing strategies.

Learn more about Costing systems here:

brainly.com/question/34005771

#SPJ3


Related Questions

The following information pertains to Lightning Inc., at the end of the year:Credit Sales $75,000 Accounts Payable 13,900 Accounts Receivable 8,200 Allowance for Uncollectible Accounts $900 creditCash Sales 24,000 Lightning uses the percentage-of-credit-sales method and estimates 4% of sales are uncollectible. What is the ending balance of the allowance account after the year-end adjustment?$3,900$4,860$3,000$2,100
The account balances and income statement of Winfrey Towing Service on June 30, 2018, follow:Equipment $18,250 Service Revinue $10,800Office Supplies 1,400 Account Receivable 8,400Notes Payable 5,000 Accounts Payable 11,000Rent Expense 550 Retined Earnings, June 1, 2018, 3,900Cash 2,200 Salries Expense 1,900Dividends 4,000 Common Stock 6,000Required:a. Prepare the statement of retained earnings for Winfrey Towing Service for the month ending June 30, 2018.b. What does the statement of a retained earnings report?
Telfer, Inc. reported net income of $2.3 million in 2020. Depreciation for the year was $157,100, accounts receivable decreased $329,900, and accounts payable decreased $302,000. Compute net cash provided by operating activities using the indirect method.
Use below information to prepare general journal entries for Belle Co.’s 1 through 7 transactions. a. D. Belle created a new business and invested $5,900 cash, $6,900 of equipment, and $12,900 in web servers in exchange for common stock. b. The company paid $6,000 cash in advance for prepaid insurance coverage. c. The company purchased $800 of supplies on account. d. The company paid $600 cash for selling expenses. e. The company received $6,000 cash for services provided. f. The company paid $800 cash toward accounts payable. g. The company paid $4,000 cash for equipment.
Gibson Company paid $12,000 on June 1, 2014 for a two-year insurance policy and recorded the entire amount as Insurance Expense. The December 31, 2014 adjusting entry is A. Debit Prepaid Insurance and credit Insurance Expense, $3,500 B. Debit Prepaid Insurance and credit Insurance Expense, $8,500 C. Debit Insurance Expense and credit Prepaid Insurance, $3,500 D. Debit Insurance Expense and credit Prepaid Insurance, $8,500

The consumer packaged goods industry is one with several large competitors, soaring raw materials prices, and strong demands from powerful retailers for lower prices. As a result, Colgate-Palmolive Co. and Unilever Group, the makers of products such as Colgate toothpaste and Ben & Jerry's ice cream respectively, both reduced their earnings forecasts. However, Procter & Gamble, another consumer packaged goods company, did not. At P&G, innovation is a key attribute, which allowed the firm to update all 200 of its brands and to develop products like Crest Whitestrips that consumers crave. P&G also used its marketing know how to develop unique product placements on television shows that highlight its brands. A SWOT analysis for P&G would indicate that soaring raw materials prices are a __________ while the product placement that features its brands on TV shows is a _________.A. strength; weakness
B. weakness; threat
C. threat; opportunity
D. opportunity; threat
E. opportunity; strength

Answers

Answer:

C. threat; opportunity

Explanation:

A SWOT analysis is a tool that companies use to identify their strengths, weaknesses, opportunities and threats:

-Strengths refer to the things that the company can do well.

-Weaknesses refer to  the things in which the company doesn't perform well.

-Opportunities refer to external situations that provide the company an advantage it can take to improve its performance.

-Threats refer to external situations that provide a difficult environment for the company to perfom well.

According to this, the answer is that a SWOT analysis for P&G would indicate that soaring raw materials prices are a threat because this an external situation that affects the company and the product placement that features its brands on TV shows is an opportunity because product placements are a form of advertising that the company can take advantage of to target its customers.

According to the "J curve effect," a weakening of the U.S. dollar relative to its trading partners' currencies would result in an initial ____ in the current account balance, followed by a subsequent ____ in the current account balance. a. decrease; decrease b. decrease; increase c. increase; increase d. increase; decrease

Answers

Answer:

Option B                      

Explanation:

In economics, the J-curve impact is frequently used to explain, for example, how a nation's trade balance negatively affects briefly after a depreciation of its exchange rate, then gradually recovers, and eventually exceeds its previous results.

If the currency of a country is appreciated, economists note, there may be a reverse J-curve. For importing nations, the country 's products unexpectedly become more competitive. When other countries will meet the gap at a cheaper profit, the stronger currency would weaken its advantage on exports.

Final answer:

According to the 'J curve effect', a weakening of the U.S. dollar would cause an initial decrease in the current account balance due to the instant effects on import and export prices. However, with time, the balance is likely to increase due to adjustments in export and import volumes. Therefore, the correct response to your question is (b) decrease; increase.

Explanation:

The 'J curve effect' is a theory in international economics that describes the likely effects of a currency devaluation on a country's trade balance. In specific, when the U.S. dollar weakens relative to its trading partners' currencies, it could initially cause a decrease in the current account balance. The reason is that the immediate effect of a weaker dollar is to make foreign imports more expensive and the U.S. exports less valuable, deteriorating the trade balance. However, in the longer term, the trade balance may increase in the current account balance. This is because over time, the cheaper U.S. exports become more appealing to overseas buyers and imports into the U.S. decrease due to their higher price, improving the balance.

So the answer to your question is: a weakening of the U.S. dollar relative to its trading partners' currencies would result in an initial decrease in the current account balance, followed by a subsequent increase in the current account balance. Hence, the correct option is (b) decrease; increase.

Learn more about J curve effect here:

brainly.com/question/31691773

#SPJ3

Felicia is looking for a new job in the insurance industry. She used to work for the controller of a retail company. What items should she add to her resume to explain her work for the controller? Select the 2 that apply.

Answers

Answer: preparing financial statements

& prepare papers for external auditor

Explanation:

Since Felicia worked for a retail company, there are definitely two things she would have being doing for the retail company that would be similar in the rod she wants to apply for at the insurance industry, they are;

-preparing financial statements;

-prepare papers for external auditor

these are a roles she would have definitely played at one point or the other for the retail store and are vital when working for the insurance industry

Jess wants to work as a public relations Specialist what academic requirements should he complete (A) bachelors degree (B) on the job training a (C) a technical program (D) a doctorate degree (E) hi school

Answers

Answer:

A

Explanation:

Answer:

"A 4-year bachelor's degree in a PR-related area like journalism, marketing or communications is frequently required for entry-level positions."-Google

So the answer should be A.

Crafting a strategy to compete in one or more foreign markets can be considered complex because 34) A) factors that affect industry competitiveness are the same from country to country. B) different government policies and economic conditions make the business climate more favorable in some countries than in others. C) the potential for location-based advantages to conducting value chain activities in certain countries. D) buyer tastes and preferences differ among countries and present a challenge for companies concerning. customizing versus standardizing their products and services. E) currency exchange rates among countries are generally fixed and rarely change.

Answers

Answer:

Options A, B, C, and E.

(Please check the explanation section before you judge or pick your answer)

Explanation:

The options A, B, C, and E are the options that are considered complex if we want to Craft a strategy to compete in one or more foreign markets.

Please take note that if the question asked us to pick which of the options is NOT a inherently complex reason when crafting a strategy to compete in one or more foreign markets then we would have picked Option D.

As given in the question, that is option D which says; '' buyer tastes and preferences creates challenges in standardizing products and services." Will not be a reason for crafting a strategy to compete in one or more foreign markets is inherently complex.

Countries due to globalization tends to participate in international trades. Competition in the international trade has its advantages as well as its disadvantages or risks.

To trade in the international market, countries must have their individual strategies and Option D above is NOT a inherently complex reason when crafting a strategy to compete in one or more foreign markets

Final answer:

Business strategies for foreign markets are complex due to differences in governmental policies, economic conditions, buyer tastes and preferences, and currency exchange rates. Hence the correct option is (C).

Explanation:

Crafting a business strategy to compete in foreign markets is indeed a complex task. This complexity arises due to variations in governmental policies and economic conditions, the different buyer tastes and preferences that need to be considered, and the fluctuating currency exchange rates across nations.

For instance, governmental policies and economic conditions may influence a country's business environment. A business-friendly government policy, stable political conditions, healthy economic indicators are desirable for the smooth functioning and growth of businesses.

Also, the tastes and preferences of buyers differ greatly from one country to another, hence making it a must for businesses to understand the local culture, traditions, and buying habits and design products/services accordingly.

In addition, Currency exchange rates can be highly volatile, adding another layer of complexity to planning and executing a business strategy for international markets.

Learn more about International Business Strategy here:

brainly.com/question/34551368

#SPJ3

Managers find operation costing useful in cost management because​ it: A. focuses on control of physical processes of a given production system B. often results in profit maximization C. uses job costing to account for the conversion costs and process costing for the material and customizable components D. results in cost minimization

Answers

Answer:

The answer is option  C) Managers find operation costing useful in cost management because​ it uses job costing to account for the conversion costs and process costing for the material and customizable components.

Explanation:

Operation costing is a mix of job costing and process costing,

In Process Costing, each process or stage of production is costed separately. while Job costing is used to calculate and assign the total cost of materials, labor, and overhead of a specific job.

The manufacture of a product may consist of several operations. In Operation Costing, costs are collected for each operation instead of each process or stage of manufacture.

Therefore, Managers find operation costing useful in cost management because​ it uses job costing to account for the conversion costs and process costing for the material and customizable components.