Module 2 Case Study (2)
.pdf
keyboard_arrow_up
School
Henderson State University *
*We aren’t endorsed by this school
Course
6093
Subject
Management
Date
Jun 18, 2024
Type
Pages
6
Uploaded by JudgePrairieDog4375
Case Study Analysis #2
Prepared by Example
For
6093 – Logistics and Supply Chain Management
Dr. Basil Miller
May 21, 2024
Financial Statements for Walmart Stores Inc. and Macy's Inc
.
Financial Statements for Walmart Stores Inc. and Macy’s Inc.
1.
Evaluate the financial performance of each company based on the various metrics discussed in Section 3.1, such as ROE, ROA, profit margin, asset turns, APT, C2C, ART, INVT, and PPET. Below in Table 1 are the financial metrics calculated for both Walmart Stores, Inc. and Macy’s Inc. based upon the financial reporting found in Appendix B –
Table 3-8. Table 1 - Comparison of Financial Metrics for Walmart Stores Inc. and Macy's Inc. Metric Unit Walmart Macy's ROE % 21.72% 24.56% ROA % 9.46% 8.28% ROFL % 12.26% 16.28% Profit Margin % 4.10% 6.22% Asset Turns Ratio 2.31 1.33 APT Ratio 5.96 3.38 ART Ratio 69.32 75.29 INVT Ratio 8.05 3.15 PPET Ratio 4.02 3.41 C2C Years -0.03 0.03 Weeks -1.51 1.80 SG&A/Revenue % 18.94% 30.22% Comparing the two companies’ financial metrics is a good way to evaluate their respective supply chain strategies. Return on Equity (ROE)
- The return on equity (ROE), the primary measure of a firm’s performance, Macy’s 24.56% outperforms Walmart
’s 21.72% by about 3%. Return on Assets (ROA)
- The return on assets for Walmart at 9.46% compared to Macy’s at 8.28% shows that both generate returns from operating and investing activities by the firm in assets. Profit Margin
–
The profit margin for Macy’s at 6.22% indicates that, in part, their customer’s willingness to pay and their good supply chain management allows them to decrease the expenses incurred to serve customer demand. That is not to say that Walmart does not. Other factors, such as everyday low pricing, increase sales of lower-margin items. Asset Turns
–
Walmart collected its money from sales relatively quickly, with an ART of 69.32. While Macy’s had a slightly higher ART of 75.29, their inventory turnover and PPET were much lower than Walmart’s. When the above are all considered, Walmart achieved a higher asset
turnover than Macy’s by turning its inventory fas
ter and generating higher revenue per dollar invested in PP&E. Accounts Payable Turnover
(APT) - The small APT of 3.38 indicates that Macy’s could use the money it owed suppliers to finance a considerable fraction of its operations in 2013. They financed their operations for about 15.38 weeks with their suppliers’ money. Walmart’s ratio APT of 5.96 results in 8.72 weeks of financing with their suppliers’ money.
Accounts Receivable Turnover (ART)
–
Macy’s and Walmart collected their money from sales relatively quickly, with an ART of 75.29 and 69.32, respectively, averaging turnover about every five days. Inventory Turnover (INVT)
–
Walmart’s INVT of 8.05 turns over almost three times faster than Macy’s
, turning over about every 45 days, whereas Macy’s turns over about every 115 days.
Property, Plant, and Equipment (PP&E)
–
Walmart generated $4.02 of revenue for each dollar invested in PP&E compared to $3.41 for Macy’s.
Cash-To-Cash (C2C)
–
Walmart collected its money for the sale of products more than 1.5 weeks before it had to pay its suppliers. On the other hand, Macy’s had to pay its suppliers about 1.8 weeks after it had to pay its suppliers. Selling, General, and Administrative (SG&A)
–
Macy’s spending for each dollar of revenue was much higher than that of Walmart. Coupled with their low PPET, this could indicate that Macy’s is leasing facilities instead of building or buying them.
2.
Can you explain the differences you see in their performance based on their supply chain strategy and structure? Walmart
’s performance in the analyzed metrics shows that they use all the drivers and levers to maximize their supply chain surplus while still obtaining an excellent ROE. Knowing they have their distribution centers (DC) geographically located according to their store locations (PPET) as well as their ability to maintain inventory at these DCs (INVT), along with their multiple mode transportation system to deliver goods to stores or homes, as appropriate, Walmart sets the example for the use of logistical drivers. Keeping ART and their C2C low shows the responsiveness and efficiency of their supply chain. Their everyday low pricing (EDLP) increases sales volume, aiding their profit margin and asset turns. Altogether, it is evident that their complete supply chain is focused on the goal of balancing responsiveness with efficiency. Macy’s performance in the varying metrics analyzed is not all that bad either. Their ROA, Asset Turns, and PPET indicate they probably lease more facilities than they build or purchase. The C2C and INVT indicate their responsiveness is slower than Walmart’s, but their efficiency may be as good. Macy’s APT and profit margin are strong and indicate their use of the pricing driver to drive profitability. Macy’s has
also achieved their focus on the complete supply chain, balancing both responsiveness and efficiency, albeit in a different way than Walmart.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Case Synopsis: Mahindra & Mahindra Ltd., a $23 billion company in 2021, has been the number one tractormanufacturer in India for the last 30 years. The agriculture tractor sale market in India is seasonal in nature andgrowing. To meet demand, the company has four manufacturing plants and 26 sales offices across the country; theirmain job is to coordinate supplies between its 800 dealers and the company. The sales offices provide a rollingdemand forecast of tractors for the current month plus two months in the future. The forecast is used to determine thenumber and models of tractors to manufacture and to support advance ordering of key modules and parts. The deputygeneral manager of sales in the company’s Farm Division has been receiving an increasing number of complaints fromirate dealers about the supply of tractors from the company’s stockyards. He needs your help to fix the situation.
1A. Discuss two additional demand management strategies or tools that MMFE could use to better…
arrow_forward
“Mickey Limited is a manufacturing business that uses a standard costing system. The company’s flexed budget for April 20X9 is:
Sales
£173,340
Costs
Direct materials
(£22,500)
Direct labour
(£37,684)
Variable production overheads
(£15,520)
Fixed production overheads
(£49,400)
Profit
48,236
The company’s directors are presented with the following standard cost operating statement for the month:”
Total
Original budgeted net profit
£44,540
Favourable
(Adverse)
Sales profit volume variance
£3,696
Sales price variance
£424
Direct materials price variance
£1,372
Direct materials quantity variance
£2,560
Direct labour rate variance
-
-
Direct labour efficiency variance
£480
Production overhead variance
£240…
arrow_forward
Determine which factor of production is needed in the following problem.
1.The ABM manufacturing Co.hired a gardener.He uses a lawn mower for landscaping.Which factor of production would you consider this machine?
2.The owner of the company withdrew cash for the salaries of thw employees.which factor of production would you consider cash on hand?
3.The top manager of the firm said "the great ideas,consepts and emotional determination of a person to produce something that consumers want to buy" is very important for the company.What factor of production describes the ability to create great ideas?
4.The farmers planted pineapple cutting in the vacant area located in their locality.Which factor of production would you consider a pineapple plantation?
arrow_forward
link of PDF :
https://docdro.id/psUSO2n
https://docdro.id/KV8USNQ
question :
1. According to Weele, why should we measure the purchasing function?
2. According to Weele, what elements in the purchasing function should we measure?
3. According to Weele, the items that we measure determines the role of the purchasing function. List these roles, and show the mapping.
4. According to Simpson and et.al, why should we measure the performance of our suppliers?
5. According to Simpson and et. al, what are the characteristics of our suppliers should we measure? List these down in terms of evaluative criteria and its details.
arrow_forward
The following annual account balances are from Armour Sports at December 31.
Accounts receivable
Net sales
Year 2
$ 10,753
143,015
Year 1
$ 53,735
624,463
a. Complete the below table to calculate the number of days' sales uncollected for the Year 1 and Year 2.
Note: Do not round intermediate calculations. Round your "Days' Sales Uncollected" to 1 decimal place.
Year 2:
Year 1:
Days' Sales Uncollected
Choose Numerator:
Choose Denominator:
x
Days
== Days' Sales Uncollected
x
Days' sales uncollected
x
=
days
days
arrow_forward
Enter the missing dollar amounts for the income statement for each of the following independent cases. (Hint: In Case B,
work from the bottom up.)
Net sales revenue
Beginning inventory
Purchases
Goods available for sale
Ending inventory
Cost of goods sold
Case A
$
Case B
7,550
$
11,140
$
6,670
4,950
8,390
15,060
10,250
11,030
5,840
Case C
$
6,060
$
3,960
9,420
13,380
8,890
4,490
Gross profit
1,310
1,570
Expenses
310
670
Pretax income (loss)
$
1,400
$
(430)
$
900
arrow_forward
Please walk me step by step for this problem
arrow_forward
Budgeting for a Merchandising Firm Goldberg Company is a retail sporting goods store thatuses an accrual accounting system. Facts regarding its operations follow:∙ Sales are budgeted at $250,000 for December and $225,000 for January, terms 1/eom, n/60.∙ Collections are expected to be 50% in the month of sale and 48% in the month following the sale.Two percent of sales are expected to be uncollectible and recorded in an allowance account at theend of the month of sale. Bad debts expense is included as part of operating expenses.∙ Gross margin is 30% of gross sales.∙ All accounts receivable are from credit sales. Bad debts are written off against the allowanceaccount at the end of the month following the month of sale.∙ Goldberg desires to have 80% of the merchandise for the following month’s sales on hand at the endof each month. Payment for merchandise is made in the month following the month of purchase.∙ Other monthly operating expenses to be paid in cash total $25,000.∙ Annual…
arrow_forward
Budgeting for a Merchandising Firm Goldberg Company is a retail sporting goods store thatuses an accrual accounting system. Facts regarding its operations follow:∙ Sales are budgeted at $250,000 for December and $225,000 for January, terms 1/eom, n/60.∙ Collections are expected to be 50% in the month of sale and 48% in the month following the sale.Two percent of sales are expected to be uncollectible and recorded in an allowance account at theend of the month of sale. Bad debts expense is included as part of operating expenses.∙ Gross margin is 30% of gross sales.∙ All accounts receivable are from credit sales. Bad debts are written off against the allowanceaccount at the end of the month following the month of sale.∙ Goldberg desires to have 80% of the merchandise for the following month’s sales on hand at the endof each month. Payment for merchandise is made in the month following the month of purchase.∙ Other monthly operating expenses to be paid in cash total $25,000.∙ Annual…
arrow_forward
Budgeting for a Merchandising Firm Goldberg Company is a retail sporting goods store thatuses an accrual accounting system. Facts regarding its operations follow:∙ Sales are budgeted at $250,000 for December and $225,000 for January, terms 1/eom, n/60.∙ Collections are expected to be 50% in the month of sale and 48% in the month following the sale.Two percent of sales are expected to be uncollectible and recorded in an allowance account at theend of the month of sale. Bad debts expense is included as part of operating expenses.∙ Gross margin is 30% of gross sales.∙ All accounts receivable are from credit sales. Bad debts are written off against the allowanceaccount at the end of the month following the month of sale.∙ Goldberg desires to have 80% of the merchandise for the following month’s sales on hand at the endof each month. Payment for merchandise is made in the month following the month of purchase.∙ Other monthly operating expenses to be paid in cash total $25,000.∙ Annual…
arrow_forward
please answer this question in 10 minutes. i will upvote
arrow_forward
CB Winter Sports specializes in providing ski lessons to beginners. The company uses the allowance method to account for
uncollectible accounts expense CB Winter Sports experienced the following four accounting events in Year 1:
1. Recognized $266,000 of revenue on account.
2. Collected $126,000 cash from accounts receivable.
3. Wrote off uncollectible accounts of $2,300,
4. Recognized uncollectible accounts expense, CB Winter Sports estimated that uncollectible accounts expense will be 3 percent of
sales on account
Required:
Use a horizontal financial statements model to show how each event affects the balance sheet, income statement, and statement of
cash flows. More specifically, record the amounts of the events into the model. Also, in the Statement of Cash Flows column, classify
the cash flows as operating activities (OA), investing activities (IA), or financing activities (FA) The first transaction is shown as an
example.
Note: Enter any decreases to account balances and cash…
arrow_forward
Is the organization in a good position to take on additional debt?
Use the Hillside, Inc. Balance Sheet information in cells A2 through D18 and cells A21 through B38 to complete the Financial Performance Calculations in cells A40 through C60.
Table 1: Hillside, Inc. Balance Sheet ($ in Millions)
ASSETS
LIABILITIES
Cash & Marketable Securities
449.90
Accounts Payable
1,611.20
Accounts Receivable
954.80
Salaries Payable
225.20
Inventories
3,645.20
Other Current Liabilities
1,118.80
Other Current Assets
116.60
Total Current Liabilities
2,955.20
Total Current Assets
5,165.27
Other Liabilities
693.40
Machinery & Equipment
1,688.90
Land
1,129.70
Total Liabilities
3,648.60
Buildings
2,348.40
Depreciation
(575.60)…
arrow_forward
Current Asset Usage Policy Payne Products had $2.4 million in sales revenues in the most recent year and expects sales growth to be 25% this year. Payne would like to determine the effect of various current assets policies on its financial performance. Payne has $3 million of fixed assets and intends to keep its debt ratio at its historical level of 50%. Payne's debt interest rate is currently 9%. You are to evaluate three different current asset policies: (1) a restricted policy in which current assets are 45% of projected sales, (2) a moderate policy with 50% of sales tied up in current assets, and (3) a relaxed policy requiring current assets of 60% of sales. Earnings before interest and taxes are expected to be 11% of sales. Payne's tax rate is 35%. What is the expected return on equity under each current asset level? Round your answers to two decimal places.
Tight policy %
Moderate policy %
Relaxed policy %
arrow_forward
By inspiring the information below, can you Create BCG matrix
arrow_forward
complete the following table to determine what are the total costs to account for if a company's beginning inventory had $231,432 in materials,
$186,450 in conversion costs, and added direct material costs ($4,231,392), direct labor ($2,313,392), and manufacturing overhead
($1,156,696)?
PLEASE NOTE: All dollar amounts are rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345). If no dollar amount is
needed for that space, please enter "$0" with no quotation marks.
Material Costs
Conversion Costs
Total Costs
Beginning work in process
4
Added:
Direct materials
Direct labor
Manufacturing overhead
Total Costs
arrow_forward
GIANTS, a sole trader extracted the following trial balance from her books at the close of business on 31st December, 2016:
Dr Cr
GHȻ GHȻ
Purchases and sales 61,420 127,245
Inventory 1 January, 2016 7,940
Capital 1 January, 2016 25,200
Bank overdraft 2,490
Cash 140
Discounts 2,480 62
Returns 3,486 1,356
Carriage outwards 3,210
Rent and insurance 8,870
Allowance for doubtful debts 630
Fixtures and fittings 1,900
Van 5,600
Accounts receivable and trade payable 12,418 11,400
Drawings 21,400
Wages and salaries 39,200
General office expenses 319
168,383 168,383
Additional information:
(a) Inventory 31st December, 2016 GHȻ 6,805
(b) Wages and salaries accrued at 31st December, 2016 GHȻ 3,500; Office expenses GHȻ 16
(c) Rent prepaid 31st December, 2016 GHȻ 600
(d) Increase in allowance for doubtful debts by GHȻ 110 to GHȻ 740
(e) Provide for depreciation as follows: Fixtures and fittings GHȻ 190 and Van GHȻ 1,400 5
Required:
a) Prepare the income statement…
arrow_forward
TRADEKINGS is a soft drink manufacturer in Zambia. Although it has a commanding share of the soft drink market in Zambia, it is facing increasing competition from a soft drink known as Atia from Kenya and the Coca-Cola line of soft drinks.
Required:
Use a Product Portfolio (SWOT) Analysis to:
Identify the opportunity OR threat to the
Identify the company’s strength OR weakness of the company
Recommend an appropriate strategy
arrow_forward
You are responsible of developing the six-month aggregate production plan at Sodas Galore, a
manufacturer of soft drinks. Your company makes three types of sodas: regular, diet and
super-caffeinated. All three types are made using the same production process, and the
switching costs can be ignored as they are so minimal. The S&OP team case created the
following forecast of demand for the next six months. In addition to the sales forecast, the
company has also developed planning values that are also shown in the next table.
Month
Sales Forecast (cases)
Softdrinks Planning Values
January
24,000
Current workforce
8 workers
32,000 Average monthly output per worker
32,000 Inventory holding cost
46,000 Regular wage rate
February
4,000 cases per month
$.30 per case per month
$20.00 per hour
March
April
May
60,000 Regular production hours/month
44,000 Overtime wage rate
160 hours
June
$30.00 per hour
240,000 Hiring cost
$1,000 per worker
$1.15 per case
Total
Subcontracting cost
Firing/layoff…
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Retailer Budget D. Tomlinson Retail seeks your assistance in developing cash and other budgetinformation for May, June, and July. The store expects to have the following balances at the end ofApril:Cash $ 5,500Accounts receivable 437,000Inventories 309,400Accounts payable 133,055The firm follows these guidelines in preparing its budgets:∙ Sales. All sales are on credit with terms of 3/10, n/30. Tomlinson bills customers on the last day ofeach month. The firm books receivables at gross amounts and collects 60% of the billings withinthe discount period, 25% by the end of the month, and 9% by the end of the second month. Thefirm’s experience suggests that 6% is likely to be uncollectible and is written off at the end of thethird month.∙ Purchases and expenses. All purchases and expenses are on open account. The firm pays its payables over a 2-month period with 54% paid in the month of purchase. Each month’s units of endinginventory should equal 130% of the next month’s cost of sales. The…
arrow_forward
The lease cost for a specialized highway design software package is estimated to be $13,000 for each of years 1, 2, and 3 (future dollars). (a) Calculate the CV amount today (year 0) of each future cost estimate at the inflation rate of 6% per year. (b) Develop a spreadsheet and graph for inflation rates of 3%, 6%, and 8% per year that show the CV today.
arrow_forward
In this document Critically analyze The Coca Cola’s Company corporate policy for funding the business operations, expansion, growth, and value creation and write 200 words ?
arrow_forward
Mirabel Manufacturing is a small but growing company that manufactures and sells marine sonar equipment. They employ a national sales force and their primary customers are marine retailers and boat dealerships. The company has expanded over the last 5 years and Paul Mirabel, the founder, and CEO has become concerned that he no longer has a clear picture of their cost structure. He calls his CFO, Mary Jane Montgomery in for a meeting.
“Mary Jane, I am concerned that I am not current on our cost structure and how that is impacting our bottom line,” Paul begins.
“Well, Paul, the company has grown considerably over the past 5 years, so I’m not surprised that you feel a little disconnected with how things are going,” Mary Jane replied. She continued “In fact, I’ve been meaning to talk to you about a couple of big items such as increasing the sales commission to 15%. We’ve lost two of our best account managers in the last 9 months. It seems like we are behind the curve paying only 12% on…
arrow_forward
XYZ Co. has provided the following data seeking your advice on the optimum investment strategy: Investment at the beginning of the year Net return data of selected investments Amount P Q R S available (£) 1 95 80 70 60 70 2 75 65 60 50 40 3 70 45 50 40 90 4 60 40 40 30 30 Maximum Investment (£) 40 50 60 60 The following additional information is also provided: o P, Q, R and S represent the selected investments o The company has decided to have four years investment plan o The policy of the company is that the amount invested in any year will remain so until the end of the fourth year o The values in the table represent net returns on investment of £1 till the end of the planning horizon Determine the optimal investment strategy. You may use the transportation technique
arrow_forward
Evaluate the firm’s short-term solvency for 2008 by computing:
a. Working Capital
b. Current Ratio
c. Acid-test/Quick Ratio
arrow_forward
Please connect our objectives to our Financial Ratios. Also, check the items there, if wrong replace them with the right ones.
Note: were doing stratma paper of NESLE.
arrow_forward
Don't need to answer any of the dropdown "select" questions
arrow_forward
1. With examples and necessary figures, define the Key Inventory Terms ?
2. Suppose, you are newly appointed as a Sales Manager in Unilever Company and after joining your first assignment is to do the sales forecast for the next quarter. Therefore, explain what would be your approach to do a good sales forecast for the next quarter.
arrow_forward
Restituto Dimaalis is VP Corporate Planning of Philippine Canning Corp. (PCC), one of the biggest fish canning companies in the Philippines with Sales of about PhP 12.0 B in 2012. Its main product is tuna with the cannery located in General Santos City, South Cotabato. Its secondary product line is sardines with the cannery located just outside Zamboanga City. The company’s head office is located in Makati.
Reviewing company performance over the past few years, Resituto thought the picture looked good. The cannery in Gen San, together with the corresponding fish port was new, having been completed 5 years ago. The company had invested a little over PhP 500.0 M in this project but it seemed to be paying off both in terms of increased efficiency as well as capacity. Most of the machinery and systems (60% of cost) was financed through 10 yr. US$ denominated debt while 30% of the balance was funded through long term PhP denominated debt and the rest through Retained Earnings. The…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON
Related Questions
- Case Synopsis: Mahindra & Mahindra Ltd., a $23 billion company in 2021, has been the number one tractormanufacturer in India for the last 30 years. The agriculture tractor sale market in India is seasonal in nature andgrowing. To meet demand, the company has four manufacturing plants and 26 sales offices across the country; theirmain job is to coordinate supplies between its 800 dealers and the company. The sales offices provide a rollingdemand forecast of tractors for the current month plus two months in the future. The forecast is used to determine thenumber and models of tractors to manufacture and to support advance ordering of key modules and parts. The deputygeneral manager of sales in the company’s Farm Division has been receiving an increasing number of complaints fromirate dealers about the supply of tractors from the company’s stockyards. He needs your help to fix the situation. 1A. Discuss two additional demand management strategies or tools that MMFE could use to better…arrow_forward“Mickey Limited is a manufacturing business that uses a standard costing system. The company’s flexed budget for April 20X9 is: Sales £173,340 Costs Direct materials (£22,500) Direct labour (£37,684) Variable production overheads (£15,520) Fixed production overheads (£49,400) Profit 48,236 The company’s directors are presented with the following standard cost operating statement for the month:” Total Original budgeted net profit £44,540 Favourable (Adverse) Sales profit volume variance £3,696 Sales price variance £424 Direct materials price variance £1,372 Direct materials quantity variance £2,560 Direct labour rate variance - - Direct labour efficiency variance £480 Production overhead variance £240…arrow_forwardDetermine which factor of production is needed in the following problem. 1.The ABM manufacturing Co.hired a gardener.He uses a lawn mower for landscaping.Which factor of production would you consider this machine? 2.The owner of the company withdrew cash for the salaries of thw employees.which factor of production would you consider cash on hand? 3.The top manager of the firm said "the great ideas,consepts and emotional determination of a person to produce something that consumers want to buy" is very important for the company.What factor of production describes the ability to create great ideas? 4.The farmers planted pineapple cutting in the vacant area located in their locality.Which factor of production would you consider a pineapple plantation?arrow_forward
- link of PDF : https://docdro.id/psUSO2n https://docdro.id/KV8USNQ question : 1. According to Weele, why should we measure the purchasing function? 2. According to Weele, what elements in the purchasing function should we measure? 3. According to Weele, the items that we measure determines the role of the purchasing function. List these roles, and show the mapping. 4. According to Simpson and et.al, why should we measure the performance of our suppliers? 5. According to Simpson and et. al, what are the characteristics of our suppliers should we measure? List these down in terms of evaluative criteria and its details.arrow_forwardThe following annual account balances are from Armour Sports at December 31. Accounts receivable Net sales Year 2 $ 10,753 143,015 Year 1 $ 53,735 624,463 a. Complete the below table to calculate the number of days' sales uncollected for the Year 1 and Year 2. Note: Do not round intermediate calculations. Round your "Days' Sales Uncollected" to 1 decimal place. Year 2: Year 1: Days' Sales Uncollected Choose Numerator: Choose Denominator: x Days == Days' Sales Uncollected x Days' sales uncollected x = days daysarrow_forwardEnter the missing dollar amounts for the income statement for each of the following independent cases. (Hint: In Case B, work from the bottom up.) Net sales revenue Beginning inventory Purchases Goods available for sale Ending inventory Cost of goods sold Case A $ Case B 7,550 $ 11,140 $ 6,670 4,950 8,390 15,060 10,250 11,030 5,840 Case C $ 6,060 $ 3,960 9,420 13,380 8,890 4,490 Gross profit 1,310 1,570 Expenses 310 670 Pretax income (loss) $ 1,400 $ (430) $ 900arrow_forward
- Please walk me step by step for this problemarrow_forwardBudgeting for a Merchandising Firm Goldberg Company is a retail sporting goods store thatuses an accrual accounting system. Facts regarding its operations follow:∙ Sales are budgeted at $250,000 for December and $225,000 for January, terms 1/eom, n/60.∙ Collections are expected to be 50% in the month of sale and 48% in the month following the sale.Two percent of sales are expected to be uncollectible and recorded in an allowance account at theend of the month of sale. Bad debts expense is included as part of operating expenses.∙ Gross margin is 30% of gross sales.∙ All accounts receivable are from credit sales. Bad debts are written off against the allowanceaccount at the end of the month following the month of sale.∙ Goldberg desires to have 80% of the merchandise for the following month’s sales on hand at the endof each month. Payment for merchandise is made in the month following the month of purchase.∙ Other monthly operating expenses to be paid in cash total $25,000.∙ Annual…arrow_forwardBudgeting for a Merchandising Firm Goldberg Company is a retail sporting goods store thatuses an accrual accounting system. Facts regarding its operations follow:∙ Sales are budgeted at $250,000 for December and $225,000 for January, terms 1/eom, n/60.∙ Collections are expected to be 50% in the month of sale and 48% in the month following the sale.Two percent of sales are expected to be uncollectible and recorded in an allowance account at theend of the month of sale. Bad debts expense is included as part of operating expenses.∙ Gross margin is 30% of gross sales.∙ All accounts receivable are from credit sales. Bad debts are written off against the allowanceaccount at the end of the month following the month of sale.∙ Goldberg desires to have 80% of the merchandise for the following month’s sales on hand at the endof each month. Payment for merchandise is made in the month following the month of purchase.∙ Other monthly operating expenses to be paid in cash total $25,000.∙ Annual…arrow_forward
- Budgeting for a Merchandising Firm Goldberg Company is a retail sporting goods store thatuses an accrual accounting system. Facts regarding its operations follow:∙ Sales are budgeted at $250,000 for December and $225,000 for January, terms 1/eom, n/60.∙ Collections are expected to be 50% in the month of sale and 48% in the month following the sale.Two percent of sales are expected to be uncollectible and recorded in an allowance account at theend of the month of sale. Bad debts expense is included as part of operating expenses.∙ Gross margin is 30% of gross sales.∙ All accounts receivable are from credit sales. Bad debts are written off against the allowanceaccount at the end of the month following the month of sale.∙ Goldberg desires to have 80% of the merchandise for the following month’s sales on hand at the endof each month. Payment for merchandise is made in the month following the month of purchase.∙ Other monthly operating expenses to be paid in cash total $25,000.∙ Annual…arrow_forwardplease answer this question in 10 minutes. i will upvotearrow_forwardCB Winter Sports specializes in providing ski lessons to beginners. The company uses the allowance method to account for uncollectible accounts expense CB Winter Sports experienced the following four accounting events in Year 1: 1. Recognized $266,000 of revenue on account. 2. Collected $126,000 cash from accounts receivable. 3. Wrote off uncollectible accounts of $2,300, 4. Recognized uncollectible accounts expense, CB Winter Sports estimated that uncollectible accounts expense will be 3 percent of sales on account Required: Use a horizontal financial statements model to show how each event affects the balance sheet, income statement, and statement of cash flows. More specifically, record the amounts of the events into the model. Also, in the Statement of Cash Flows column, classify the cash flows as operating activities (OA), investing activities (IA), or financing activities (FA) The first transaction is shown as an example. Note: Enter any decreases to account balances and cash…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Understanding BusinessManagementISBN:9781259929434Author:William NickelsPublisher:McGraw-Hill EducationManagement (14th Edition)ManagementISBN:9780134527604Author:Stephen P. Robbins, Mary A. CoulterPublisher:PEARSONSpreadsheet Modeling & Decision Analysis: A Pract...ManagementISBN:9781305947412Author:Cliff RagsdalePublisher:Cengage Learning
- Management Information Systems: Managing The Digi...ManagementISBN:9780135191798Author:Kenneth C. Laudon, Jane P. LaudonPublisher:PEARSONBusiness Essentials (12th Edition) (What's New in...ManagementISBN:9780134728391Author:Ronald J. Ebert, Ricky W. GriffinPublisher:PEARSONFundamentals of Management (10th Edition)ManagementISBN:9780134237473Author:Stephen P. Robbins, Mary A. Coulter, David A. De CenzoPublisher:PEARSON
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON