Question

In: Finance

Please format answer into a table Calculate gross sales, variable costs, and gross margin (profit) for...

Please format answer into a table

  1. Calculate gross sales, variable costs, and gross margin (profit) for each product and for an entire company.
  2. Calculate break-even sales dollars for a company.
  3. Determine the relevant cash flows for a planned asset purchase.

    Madison Company produces four lines of accessories for major U.S. combine manufacturers. The lines are known by the code letters A, B, C, and D. The current sales mix for Madison Company and the contribution margin ratio for these product lines are as follows:

    Product Line Percentage of Total Sales Contribution Margin Ratio
    A 23.67 % 36.00 %
    B 39.33 % 42.00 %
    C 21.67 % 24.00 %
    D 15.33 % 56.00 %

    Assume total sales for next year are forecast to be $3,500,000 and total fixed costs will be $525,000.

  4. Prepare a table showing the values for sales, total variable costs, and the contribution margin (gross profit) associated with each product line and the company as a whole. (15 points total – one point per table value)
  5. Calculate break-even sales dollars for the Madison Company. (2 points)

Solutions

Expert Solution

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

The Brenmar Sales Company had a gross profit margin (gross profit/sales) of 28% and sales of...
The Brenmar Sales Company had a gross profit margin (gross profit/sales) of 28% and sales of $8.6 million last year. 70% of the firm’s sales are in credit, and the remainder are cash sales. Brenmar’s current assets equal $1.4 million, its current liabilities equal $299,000, and it has $106,000 in cash plus marketable securities. A. If Brenmar’s accounts receivable equal $562,600, what is its average collection period? B. If Brenmar reduces its average collection period is 25 days, what will...
The Brenmar Sales Company had a gross profit margin (gross profits /  sales) of 28% and sales...
The Brenmar Sales Company had a gross profit margin (gross profits /  sales) of 28% and sales of $8.3 million last year. 73% of the firm's sales are on credit, and the remainder are cash sales. Bertram's current assets equal $1.4 million, its current liabilities equal $299,999, and it has $108,000 in cash plus marketable securities. A. If Brenmar's accounts receivable equal $563,100, what is its average collection period? B. If Brenmar reduces its average collection period to 20 days, what...
The Brenmar Sales Company had a gross profit margin (gross profits divided by ÷ sales) of...
The Brenmar Sales Company had a gross profit margin (gross profits divided by ÷ sales) of 26 percent and sales of $9.3 million last year. 79 percent of the firm's sales are on credit, and the remainder are cash sales. Brenmar's current assets equal $1.8 million, its current liabilities equal $ 303,500, and it has $104,100 in cash plus marketable securities. a. If Brenmar's accounts receivable equal $563,000 , what is its average collection period? b. If Brenmar reduces its...
Calculate the contribution margin (selling price minus variable costs) and gross margin (selling price minus all...
Calculate the contribution margin (selling price minus variable costs) and gross margin (selling price minus all manufacturing costs) per gallon for each type of paint and total firm-wide profit under each of the following scenarios: Scenario A Current production, including the Virginia contract Scenario B Without either the Virginia contract or the promotion to expand sales of commercial paint Scenario C Without the Virginia contract but assuming the promotional campaign is undertaken and sales of commercial paint do in fact...
The Brenmar Sales Company had a gross profit margin (gross profits divided by sales) of 31%...
The Brenmar Sales Company had a gross profit margin (gross profits divided by sales) of 31% and sales of $9.8 million last year. 80% of the firm's sales are on credit, and the remainder are cash sales. Brenmar's current assets equal $1.5 million, it's current liabilities equal $303,000 and it has $103,100 in cash plus marketable securities. Please answer the following, a. If Brenmar's accounts receivable equal $561,800 what is the average collection period? b. If Brenmar reduces its average...
Contribution Margin Format Example: Volume XX Sales XX Variable Costs (Listed) XX Variable Costs (Total) XX...
Contribution Margin Format Example: Volume XX Sales XX Variable Costs (Listed) XX Variable Costs (Total) XX Contribution Margin XX Fixed Costs (Listed) XX Fixed Costed (Total) XX Operating Income XX Vroom-Vroom manufactures ride-on cars for toddlers and young children. They have a fiscal year of January through December. When they were preparing their budget, they couldn’t decide if a static or flexible budget would be best for their company – so they did both. It is now March, and their...
Calculating Gross Profit Margin and Inventory Turnover The following table presents sales revenue, cost of goods...
Calculating Gross Profit Margin and Inventory Turnover The following table presents sales revenue, cost of goods sold, and inventory amounts for three retailers of fine jewelry, Tiffany & Co., Zale Corporation, and Blue Nile, Inc. (an Internet retailer). ($ millions) 2013 2012 Tiffany & Co. Revenues $4,585 $4,017 Cost of goods sold 1,776 1,674 Inventory 2,489 2,347 Zale Corporation Revenues $1,973 $1,910 Cost of goods sold 989 949 Inventory 823 769 Blue Nile, Inc. Revenues $505 $443 Cost of goods...
Calculating Gross Profit Margin and Inventory Turnover The following table presents sales revenue, cost of goods...
Calculating Gross Profit Margin and Inventory Turnover The following table presents sales revenue, cost of goods sold, and inventory amounts for three retailers of fine jewelry, Tiffany & Co., Zale Corporation, and Blue Nile, Inc. (an Internet retailer). ($ millions) 2013 2012 Tiffany & Co. Revenues $4,231 $3,974 Cost of goods sold 1,766 1,664 Inventory 2,477 2,335 Zale Corporation Revenues $1,963 $1,900 Cost of goods sold 979 939 Inventory 813 759 Blue Nile, Inc. Revenues $495 $433 Cost of goods...
Please calculate the following based on the facts provided: a. Gross Margin Ratio: Net sales =...
Please calculate the following based on the facts provided: a. Gross Margin Ratio: Net sales = $1,000,000.00 & Cost of Goods Sold = $200,000.   b. Return on assets ratio (ROA): Net Income = $350,000 & Average Total Assets = $2,500,000 c. Return on Equity (ROE): Net Income = $350,000 & Shareholder's Equity = $5,000,000. d. Customer Acquisition Cost (CAC): Sales/Marketing Costs = $450,000 & number of new customers 1,000.    e. Current Liquidity Ratio: Current Assets = $1,200,000 & Current...
​(Efficiency analysis)  The Brenmar Sales Company had a gross profit margin​ (gross profits divided by ​sales)...
​(Efficiency analysis)  The Brenmar Sales Company had a gross profit margin​ (gross profits divided by ​sales) of 25 percent and sales of $ 9.2 million last year.  73 percent of the​ firm's sales are on​ credit, and the remainder are cash sales. ​ Brenmar's current assets equal $ 1.7 ​million, its current liabilities equal $ 301 comma 400​, and it has $ 100 comma 000 in cash plus marketable securities. a. If​ Brenmar's accounts receivable equal $ 562 comma 000​,...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT