Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Robin Polaski, the Materials Manager of Seppa Firm, is interested in assessing the inventory management performance of the firm. The annual income statement and quarterly
Robin Polaski, the Materials Manager of Seppa Firm, is interested in assessing the inventory management performance of the firm. The annual income statement and quarterly balance sheets from last year are shown.
A. How many weeks of supply does the Seppa Firm carry? CLEARLY LABEL YOUR ANSWER BELOW. SHOW YOUR WORK BELOW,
B. How many inventory turns did Seppa Firm go through? CLEARLY LABEL YOUR ANSWER BELOW. SHOW YOUR WORK BELOW,
Inventory Analysis Problem Seppa Firm Income Statement FY 2022 \begin{tabular}{|l|rr|} \hline Net Sales & $ & 800,000 \\ \hline Cost of goods sold & $ & 540,000 \\ \hline Gross profit & $ & 260,000 \\ \hline Operating expenses & $ & 87,000 \\ \hline Net income & $ & 173,000 \\ \hline \end{tabular} Seppa Firm Quarterly Balance Sheet FY 2022 \begin{tabular}{|l|rr|rr|rr|rr|} \cline { 2 - 8 } & \multicolumn{2}{|c|}{ 1st Quarter } & \multicolumn{2}{c|}{ 2nd Quarter } & \multicolumn{2}{c|}{ 3rd Quarter } & \multicolumn{2}{c|}{ 4th Quarter } \\ \hline Cash & $ & 37,000 & $ & 29,000 & $ & 26,000 & $ & 26,000 \\ \hline Accounts receivable & $ & 17,700 & $ & 10,800 & $ & 9,800 & $ & 11,800 \\ \hline \end{tabular} Inventory \begin{tabular}{|l|rr|rr|rr|rr|} \hline Finished goods & $ & 10,700 & $ & 11,500 & $ & 11,000 & $ & 11,000 \\ \hline Work in process & $ & 7,000 & $ & 5,300 & $ & 5,800 & $ & 6,200 \\ \hline Materials & $ & 8,200 & $ & 8,500 & $ & 7,900 & $ & 8,600 \\ \hline \end{tabular} \begin{tabular}{|l|ll|ll|ll|ll|} \hline Plant assets & $ & 520,000 & $ & 520,000 & $ & 510,000 & $ & 510,000 \\ \hline \end{tabular} The company operates 52 weeks every yearStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started