Homework Answers
| Department A | Department B | Department C | Department D | Department E | Department F | |
| Sales = Turover x Average inventory | $ 1.50 | $ 1.40 | $ 78.00 | $ 180.00 | $ 32.50 | $ 45.20 |
| Turnover = Sales/ average inventory | 7.2 | 3.5 | 4.5 | 12 | 7.22 | 6.37 |
| Average Inventory = Sales/ turnover | $ 0.21 | $ 0.40 | $ 17.33 | $ 15.00 | $ 4.50 | $ 7.10 |
| COGS (sales - Gross Margin) | $ 0.80 | $ 0.60 | $ 52.30 | $ 41.30 | $ 19.60 | $ 29.40 |
| Gross Margin _ Dollars | $ 0.70 | $ 0.80 | $ 25.70 | $ 138.70 | $ 12.90 | $ 15.80 |
| Gross Margin _ Percent = GM/Sales | 47% | 57% | 33% | 77% | 40% | 35% |
| GMROI = Gross Profit/ Average Inventory | 3.36 | 2.00 | 1.48 | 9.25 | 2.87 | 2.23 |
Add Answer to:
3. Complete the following grid: Department Department D B $78.0 $32.5 $1.5 Sales $45.2 12.0 3.5...
solving Problems A retailer's current assets are $7.4 milli The retailer wants to be rells him...
solving Problems A retailer's current assets are $7.4 milli The retailer wants to be rells him that, to borrow m ets are $7.4 million. Presently, his current ratio is 1.5. ants to borrow money to fund an expansion: however, a lender horrow money, the retailer must bring his current ratio up t's current liabilities? By how much must he reduce ilities to obtain a loan, assuming that current assets remain What are the retailer's current liabilities? By h to 2.0....
perfo Solving Problems 1. A retailers current assets are $7.4 million Presently, his current ratio is...
perfo Solving Problems 1. A retailers current assets are $7.4 million Presently, his current ratio is .5.) The retailer wants to borrow money to fund an expansion; however, a lender tells him that, to borrow money, the retailer must bring his current ratio up to 2.0. What are the retailer's current liabilities? By how much must he reduce his current liabilities to obtain a loan, assuming that current assets remain constant? 2 Complete the following grid: Store 1 Store 2...
2. Complete the following grid: Store 3 Ner Sales Cast of goods sold Gros margin-dollars Groos...
2. Complete the following grid: Store 3 Ner Sales Cast of goods sold Gros margin-dollars Groos margin-percent Expenses---dollars Expenses-percent Net income-dollars Net income-percent Dollars expressed in millions Store 1 Store 2 Store 4 Store 5 Store 6 $12.0 80.7 $155.0 1,438.8.131.6 $4,056.7 6.1 $42. 6 5 9.2 $951.2 $90.0 1,619.5 $5.9 $38.1 65.8 $487.6 41.6 $2,387.2 49.2% 47.2% 61.8% 33.9731.6% 58.8% $4.2 31.9 $88.2 464.9 $41.1 2,259.7 35.0% 39.5% 56.9% 32.3% 31.2% 55.71 1.7 $6.2 $7.6 $22.7 $0.5 $128.5 114.2%...
CUI 2. Complete the following grid: Store 1 Store 2 Store 4 Store 3 $155.0 Store...
CUI 2. Complete the following grid: Store 1 Store 2 Store 4 Store 3 $155.0 Store 5 $12.0 Store 6 $4,056.7 $42.6 $90.0 $5.9 $38.1 $951.2 $487.6 $2,387.2 Net Sales Cost of goods sold Gross margin-dollars Gros margin-percent Expenses-dollars Expenses--percent Net income-dollars $4.2 $88.2 $41.1 $6.2 $7.6 $22.7 $0.5 $128.5 Net income-percent Dollars expressed in millions
Uncle Ernie's Lumber Emporium Read the following scenario and complete the financial statements a...
Uncle Ernie's Lumber Emporium Read the following scenario and complete the financial statements and calculate the appropriate financial ratios I have attached a file containing an Excel spreadsheet for your convenience Part-1 Your uncle Ernie just passed away and left you his lumber yard. The will says that you must operate the lumberyard for at least five years after his death; after the five year period you can sell it or continue to operate it. Going through last year's records...
1. 2. 3. A E 1 2 3 4 B с D Productive Capacity 50,000 units...
1.
2.
3.
A E 1 2 3 4 B с D Productive Capacity 50,000 units Fixed Budget For the year ended December 31, 2020 Per Unit Total Sales $250 $9,375,000 Variable costs 180 6,750,000 Contribution margin $70 2,625,000 Fixed Expenses 2,500,000 Operating Income $125,000 5 6 7 8 9 10 11 12 13 Flexible Budget For the year ended December 31, 2020 % of productive capacity 70% Units produced and sold 35,000 75% 37,500 80% 40,000 14 15 16...
QUESTIONS 1. Complete the 1992 columns of Tables 3 through 6, disregarding for now the projected...
QUESTIONS 1. Complete the 1992 columns of Tables 3 through 6, disregarding for now the projected data in the 1993 and 1994 columns. If you are using the spreadsheet model, use it to complete the tables. Be sure you understand all the numbers, as it would be most embarrassing and harmful to your career) if you were asked how you got a particular number and you could not give a meaningful response. 2. Based on the information in the case...
How to get picture 1 "Cost of Sales" and picture 2 "Net Income or Net Earnings",...
How to get picture 1 "Cost of Sales" and picture 2 "Net Income
or Net Earnings", thank you.
February 1, 2020 February 2 2019 Year Ended February 3, 2018 Jamiary 28, 2017 January 30, 2016 3. Total Assets S S Total Liabilities Total Equity or Total Shareholders Investments Financial Statement Name as stated in the 10-K Statement of Operations Data: Net sales Gross profit Selling, general and administrative expenses Operating income (loss) 23,610.8 S 7,040.7 5.778.5 1.262.2 22,823.3 $ 6.947.5...
(2) Schedules Complete the sales and merchandise purchase plans with supporting schedules: a) A sales plan...
(2) Schedules
Complete the sales and merchandise purchase plans with supporting
schedules:
a) A sales plan by month and in total, including a schedule of
projected cash collections from sales and accounts receivable, by
month and in total (2 schedules).
b) An inventory purchases plan in units and in dollars, including a
schedule of projected cash payments for purchases, by month and in
total (3 schedules).
NOTE: All schedules and budgets should be calculated based on
information entered into the...
Question (5) Directions: Click the "Case-link" displayed above and use the information provided in Hearth and...
Question (5) Directions: Click the "Case-link" displayed above and use the information provided in Hearth and Home, Parts A and B, to answer this question: In a downside-case scenario, you assume that a recession slows housing starts by 30 percent. If so, which of the following hypotheses would be the most reasonable? O Cost of goods sold and SG&A expenses both decrease as percentages of sales O Gross profit margin decreases and SG&A expenses decrease as percentages of sales OInventory...
solving Problems A retailer's current assets are $7.4 milli The retailer wants to be rells him that, to borrow m ets are $7.4 million. Presently, his current ratio is 1.5. ants to borrow money to fund an expansion: however, a lender horrow money, the retailer must bring his current ratio up t's current liabilities? By how much must he reduce ilities to obtain a loan, assuming that current assets remain What are the retailer's current liabilities? By h to 2.0....
perfo Solving Problems 1. A retailers current assets are $7.4 million Presently, his current ratio is .5.) The retailer wants to borrow money to fund an expansion; however, a lender tells him that, to borrow money, the retailer must bring his current ratio up to 2.0. What are the retailer's current liabilities? By how much must he reduce his current liabilities to obtain a loan, assuming that current assets remain constant? 2 Complete the following grid: Store 1 Store 2...
2. Complete the following grid: Store 3 Ner Sales Cast of goods sold Gros margin-dollars Groos margin-percent Expenses---dollars Expenses-percent Net income-dollars Net income-percent Dollars expressed in millions Store 1 Store 2 Store 4 Store 5 Store 6 $12.0 80.7 $155.0 1,438.8.131.6 $4,056.7 6.1 $42. 6 5 9.2 $951.2 $90.0 1,619.5 $5.9 $38.1 65.8 $487.6 41.6 $2,387.2 49.2% 47.2% 61.8% 33.9731.6% 58.8% $4.2 31.9 $88.2 464.9 $41.1 2,259.7 35.0% 39.5% 56.9% 32.3% 31.2% 55.71 1.7 $6.2 $7.6 $22.7 $0.5 $128.5 114.2%...
CUI 2. Complete the following grid: Store 1 Store 2 Store 4 Store 3 $155.0 Store 5 $12.0 Store 6 $4,056.7 $42.6 $90.0 $5.9 $38.1 $951.2 $487.6 $2,387.2 Net Sales Cost of goods sold Gross margin-dollars Gros margin-percent Expenses-dollars Expenses--percent Net income-dollars $4.2 $88.2 $41.1 $6.2 $7.6 $22.7 $0.5 $128.5 Net income-percent Dollars expressed in millions
Uncle Ernie's Lumber Emporium Read the following scenario and complete the financial statements and calculate the appropriate financial ratios I have attached a file containing an Excel spreadsheet for your convenience Part-1 Your uncle Ernie just passed away and left you his lumber yard. The will says that you must operate the lumberyard for at least five years after his death; after the five year period you can sell it or continue to operate it. Going through last year's records...
1.
2.
3.
A E 1 2 3 4 B с D Productive Capacity 50,000 units Fixed Budget For the year ended December 31, 2020 Per Unit Total Sales $250 $9,375,000 Variable costs 180 6,750,000 Contribution margin $70 2,625,000 Fixed Expenses 2,500,000 Operating Income $125,000 5 6 7 8 9 10 11 12 13 Flexible Budget For the year ended December 31, 2020 % of productive capacity 70% Units produced and sold 35,000 75% 37,500 80% 40,000 14 15 16...
QUESTIONS 1. Complete the 1992 columns of Tables 3 through 6, disregarding for now the projected data in the 1993 and 1994 columns. If you are using the spreadsheet model, use it to complete the tables. Be sure you understand all the numbers, as it would be most embarrassing and harmful to your career) if you were asked how you got a particular number and you could not give a meaningful response. 2. Based on the information in the case...
How to get picture 1 "Cost of Sales" and picture 2 "Net Income
or Net Earnings", thank you.
February 1, 2020 February 2 2019 Year Ended February 3, 2018 Jamiary 28, 2017 January 30, 2016 3. Total Assets S S Total Liabilities Total Equity or Total Shareholders Investments Financial Statement Name as stated in the 10-K Statement of Operations Data: Net sales Gross profit Selling, general and administrative expenses Operating income (loss) 23,610.8 S 7,040.7 5.778.5 1.262.2 22,823.3 $ 6.947.5...
(2) Schedules
Complete the sales and merchandise purchase plans with supporting
schedules:
a) A sales plan by month and in total, including a schedule of
projected cash collections from sales and accounts receivable, by
month and in total (2 schedules).
b) An inventory purchases plan in units and in dollars, including a
schedule of projected cash payments for purchases, by month and in
total (3 schedules).
NOTE: All schedules and budgets should be calculated based on
information entered into the...
Question (5) Directions: Click the "Case-link" displayed above and use the information provided in Hearth and Home, Parts A and B, to answer this question: In a downside-case scenario, you assume that a recession slows housing starts by 30 percent. If so, which of the following hypotheses would be the most reasonable? O Cost of goods sold and SG&A expenses both decrease as percentages of sales O Gross profit margin decreases and SG&A expenses decrease as percentages of sales OInventory...
Most questions answered within 3 hours.
-
4. The excitation of a 414 V, 3-phase, delta-connected
synchronous motor is such that that the...
asked 9 minutes ago -
3. (20 pts) In the Carnot engine (refer to the figure in
question 2), an ideal...
asked 16 minutes ago -
A contestant is facing 10 closed doors. Behind one of these
doors there is a prize....
asked 17 minutes ago -
Showing appropriate work and equations, what is the yield to
maturity on a share of Six...
asked 33 minutes ago -
what would be the best entry mode in shipping from the U.S to Spain
by boat...
asked 37 minutes ago -
Under certain conditions, the substance ammonium
nitrate can be broken down to form dinitrogen
monoxide and...
asked 38 minutes ago -
1. A boy stands on one end of a boat, and then walks to the
other...
asked 49 minutes ago -
Casey is on trial under criminal allegations that she engaged in
fraudulent behavior at the company...
asked 54 minutes ago -
Surplus Styles is a manufacturer of hair care products,
including shampoos, conditioners, and hair gels. The...
asked 52 minutes ago -
Using an income-expenditure diagram, use the infinite line and
double-drop line tools to show the economy...
asked 1 hour ago -
Which expression computes a pseudorandom integer between -10 and
10 using rand()
from cstdlib?
A. (rand(...
asked 1 hour ago -
Roybus, Inc., a manufacturer of flash memory, just reported that
its main production facility in Taiwan...
asked 1 hour ago