Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I attended our industrys showcase conference last month and learned that Chester is updating their pricing strategy for their product Cure. Early intel suggests that

I attended our industrys showcase conference last month and learned that Chester is updating their pricing strategy for their product Cure. Early intel suggests that theyll drop the price $1.70. Theyll likely continue to keep both material and labor costs consistent at 6.16 and 6.88 per unit respectively and I want us to better understand what their break-even point is.

How many units (000) of Cure must they sell to break even? You can expect their period costs to stay consistent with the Income Statement available in your Drive.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

\begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{CashFlowStatement} \\ \hline & Andrews & Baldwin & Chester & Digby & Erie & Ferris \\ \hline \multicolumn{7}{|l|}{ Cash From Operations } \\ \hline Net Income(Loss) & $12,972 & $12,738 & $5,111 & $7,468 & $7,811 & $6,850 \\ \hline \multicolumn{7}{|l|}{ Adjustment For Non-Cash Items } \\ \hline Depreciation & $11,649 & $11,210 & $10,791 & $12,157 & $11,835 & $12,242 \\ \hline Extraordinary Gains/Losses/Write-offs & $0 & $0 & $47 & $0 & $0 & $90 \\ \hline \multicolumn{7}{|l|}{ Changes In Current Assets And Liabilities } \\ \hline Accounts Payable & $4,434 & $1,740 & $3,736 & $2,243 & $2,083 & $3,313 \\ \hline Inventory & ($11,633) & ($6,153) & ($16,767) & ($2,951) & ($19,841) & ($7,425) \\ \hline Accounts Receivable & ($3,073) & ($1,465) & ($2,727) & ($1,617) & ($895) & ($4,151) \\ \hline Net Cash From Operations & $14,348 & $18,069 & $191 & $17,299 & $993 & $10,919 \\ \hline \multicolumn{7}{|l|}{ Cash From Investing } \\ \hline Net Plant Improvements & ($26,136) & ($21,145) & ($28,460) & ($48,556) & ($36,926) & ($25,448) \\ \hline \multicolumn{7}{|l|}{ Cash From Financing } \\ \hline Dividends Paid & $0 & ($2,588) & $0 & $0 & $0 & $0 \\ \hline Sales Of Common Stock & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline Purchase Of Common Stock & ($3,603) & ($5,602) & ($5,086) & ($6,321) & ($619) & $0 \\ \hline Cash From Long-Term Debt Issued & $0 & $0 & $0 & $5,396 & $5,394 & $20,561 \\ \hline Early Retirement Of Long-Term Debt & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline Retirement Of Current Debt & ($12,100) & ($5,800) & ($6,300) & ($4,300) & $0 & ($14,400) \\ \hline Cash From Current Debt Borrowing & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline Cash From Emergency Loan & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline Net Cash From Financing & ($15,703) & ($13,990) & ($11,386) & ($5,225) & $4,775 & $6,161 \\ \hline Net Change In Cash & ($27,491) & ($17,066) & ($39,656) & ($36,482) & ($31,158) & ($8,368) \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{10}{|c|}{ Income Statement } \\ \hline & Clack & Cure & Cone & Cozy & Cedar & Cid & Total & Industry Avg & Percentage \\ \hline Sales & $15,639 & $27,923 & $36,063 & $27,130 & $34,684 & $35,442 & $176,881 & $164,456 & 100% \\ \hline \multicolumn{10}{|l|}{ Variable Costs } \\ \hline Direct Material & $5,423 & $7,090 & $15,008 & $12,827 & $12,981 & $15,488 & $68,817 & $60,674 & 38.9% \\ \hline Direct Labor & $6,934 & $9,144 & $10,671 & $7,056 & $10,291 & $7,565 & $51,661 & $43,836 & 29.2% \\ \hline Inventory Carry & $317 & $159 & $958 & $477 & $513 & $0 & $2,423 & $1,575 & 1.4% \\ \hline Total Variable Costs (Labor, Material, Carry) & $12,674 & $16,393 & $26,637 & $20,360 & $23,785 & $23,052 & $122,901 & $106,085 & 69.5% \\ \hline Contribution Margin & $2,964 & $11,530 & $9,426 & $6,770 & $10,899 & $12,389 & $53,979 & $58,372 & 30.5% \\ \hline \multicolumn{10}{|l|}{ Period Costs } \\ \hline Depreciation & $1,549 & $2,946 & $1,476 & $1,438 & $1,872 & $1,510 & $10,791 & $11,647 & 6.1% \\ \hline \multicolumn{10}{|l|}{ SG\&A } \\ \hlineR&D & $79 & $829 & $1,000 & $921 & $889 & $981 & $4,699 & $2,941 & 2.7% \\ \hline Sales & $805 & $1,280 & $1,370 & $1,370 & $1,370 & $1,370 & $7,563 & $7,282 & 4.3% \\ \hline Administration & $139 & $248 & $320 & $241 & $308 & $314 & $1,569 & $1,353 & 0.9% \\ \hline Total Period Costs & $3,551 & $6,483 & $5,585 & $5,389 & $5,857 & $5,595 & $32,460 & $30,337 & 18.4% \\ \hline \multirow[t]{8}{*}{ Net Margin } & ($587) & $5,048 & $3,841 & $1,381 & $5,042 & $6,795 & $21,519 & $28,035 & 12.2% \\ \hline & & & & & \multicolumn{2}{|c|}{ Other Expenses } & $5,740 & $6,161 & 3.2% \\ \hline & & & & & \multicolumn{2}{|r|}{ EBIT } & $15,780 & $21,873 & 8.9% \\ \hline & & & & & \multicolumn{2}{|c|}{ Short-Term Interest } & $1,571 & $1,529 & 0.9% \\ \hline & & & & & \multicolumn{2}{|c|}{ Long-Term Interest } & $6,186 & $6,491 & 3.5% \\ \hline & & & & & \multicolumn{2}{|c|}{ Taxes \& Tariffs } & $2,808 & $4,849 & 1.6% \\ \hline & & & & & \multicolumn{2}{|c|}{ Profit Sharing } & $104 & $180 & 0.1% \\ \hline & & & & & \multicolumn{2}{|r|}{ Net Profit } & $5,111 & $8,825 & 2.9% \\ \hline \end{tabular} Stock \& Bonds Round: 4 Dec. 31, 2026 \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline \multicolumn{8}{|c|}{ Selected Financial Statistics } \\ \hline & Andrews & Baldwin & Chester & Digby & Erie & Ferris & Average \\ \hline ROS & 6.4% & 7.6% & 2.9% & 4.4% & 5.7% & 5.2% & 5.4% \\ \hline Asset Turnover & 1.17 & 1.04 & 1.16 & 1.05 & 0.88 & 0.79 & 1.01 \\ \hline ROA & 7.5% & 7.9% & 3.4% & 4.7% & 5.0% & 4.1% & 5.4% \\ \hline Leverage & 1.80 & 1.75 & 1.93 & 1.85 & 1.85 & 1.89 & 1.85 \\ \hline ROE & 13.4% & 13.8% & 6.5% & 8.6% & 9.3% & 7.7% & 9.9% \\ \hline Sales & $203,679 & $168,112 & $176,881 & $168,065 & $137,547 & $132,455 & $164,457 \\ \hline EBIT & $28,443 & $27,523 & $15,780 & $19,664 & $20,105 & $19,726 & $21,874 \\ \hline Profit & $12,972 & $12,738 & $5,111 & $7,468 & $7,811 & $6,850 & $8,825 \\ \hline Cumulative Profit & $17,157 & $16,923 & $9,296 & $11,653 & $11,996 & $11,036 & $13,010 \\ \hline SG\&A to Sales Ratio & 10.97% & 11.42% & 12.25% & 10.87% & 13.68% & 8.94% & 11.35% \\ \hline Contribution Margin & 32.27% & 38.84% & 30.52% & 32.92% & 41.96% & 39.41% & 35.99% \\ \hline Emergency Loan & $0 & $0 & $0 & $0 & $0 & $0 & $0 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline \multicolumn{7}{|c|}{ Balance Sheet } \\ \hline & Andrews & Baldwin & Chester & Digby & Erie & Ferris \\ \hline Cash & $27,352 & $32,881 & $7,485 & $24,564 & $4,006 & $26,460 \\ \hline Accounts Receivable & $16,741 & $13,817 & $14,538 & $13,814 & $11,305 & $10,887 \\ \hline Inventory & $17,065 & $9,228 & $20,194 & $2,951 & $21,905 & $7,425 \\ \hline Total Current Assets & $61,158 & $55,926 & $42,218 & $41,329 & $37,216 & $44,771 \\ \hline Plant And Equipment & $174,736 & $168,145 & $161,867 & $182,356 & $177,526 & $183,632 \\ \hline Accumulated Depreciation & ($62,536) & ($62,176) & ($52,038) & ($63,190) & ($58,855) & ($59,736) \\ \hline Total Fixed Assets & $112,201 & $105,969 & $109,829 & $119,166 & $118,671 & $123,896 \\ \hline Total Assets & $173,358 & $161,895 & $152,047 & $160,495 & $155,887 & $168,668 \\ \hline Accounts Payable & $12,127 & $8,866 & $11,280 & $9,480 & $7,976 & $7,133 \\ \hline Current Debt & $13,900 & $13,900 & $13,900 & $13,900 & $13,900 & $13,900 \\ \hline Long-Term Debt & $50,850 & $46,850 & $48,250 & $50,446 & $49,644 & $58,611 \\ \hline Total Liabilities & $76,877 & $69,616 & $73,430 & $73,826 & $71,520 & $79,645 \\ \hline Common Stock & $42,141 & $40,123 & $36,626 & $37,191 & $33,588 & $46,760 \\ \hline Retained Earnings & $54,340 & $52,156 & $41,991 & $49,477 & $50,779 & $42,263 \\ \hline Total Equity & $96,481 & $92,279 & $78,616 & $86,668 & $84,367 & $89,023 \\ \hline Total Liabilities \& Owner's Equity & $173,358 & $161,895 & $152,047 & $160,495 & $155,887 & $168,668 \\ \hline \multicolumn{7}{|c|}{ Income Statement } \\ \hline & Andrews & Baldwin & Chester & Digby & Erie & Ferris \\ \hline Sales & $203,679 & $168,112 & $176,881 & $168,065 & $137,547 & $132,455 \\ \hline Total Variable Costs (Labor, Material, Carry) & $137,958 & $102,820 & $122,901 & $112,746 & $79,829 & $80,255 \\ \hline Depreciation & $11,649 & $11,210 & $10,791 & $12,157 & $11,835 & $12,242 \\ \hlineSG&A & $22,333 & $19,194 & $21,669 & $18,276 & $18,821 & $11,844 \\ \hline Other (Fees/Write-offs/Bonuses/Relocation Fee) & $3,295 & $7,366 & $5,740 & $5,223 & $6,956 & $8,389 \\ \hline EBIT & $28,443 & $27,523 & $15,780 & $19,664 & $20,105 & $19,726 \\ \hline Interest (Short-Term/Long-Term) & $8,079 & $7,526 & $7,756 & $7,941 & $7,843 & $8,972 \\ \hline Taxes & $7,127 & $6,999 & $2,808 & $4,103 & $4,292 & $3,764 \\ \hline Profit Sharing & $265 & $260 & $104 & $152 & $159 & $140 \\ \hline Net Profit & $12,972 & $12,738 & $5,111 & $7,468 & $7,811 & $6,850 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Energy Audit Of Building Systems An Engineering Approach

Authors: Moncef Krarti

3rd Edition

0367820463, 978-0367820466

More Books

Students also viewed these Accounting questions

Question

4. Does cultural aptitude impact ones emotional intelligence?

Answered: 1 week ago