The plant manager at Track Technologies collected some performance metrics of his manufacturing facility. The table...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The plant manager at Track Technologies collected some performance metrics of his manufacturing facility. The table below shows the financial data available for last year and this year. Last year This year Sales $215,000 $228,000 Costs of goods sold $121,000 $131,000 Gross margin $94,000 $97,000 Net income $45,000 $48,000 Finished goods inventory $2,000 $5,000 WIP Inventory $10,000 $12,000 Raw Material Inventory $5,000 $6,000 Total inventory (avg/year) $17,000 $23,000 Other current assets $91,000 $110,000 Other assets $213,000 $242,000 Total Assets $321,000 $375,000 1) Based on the total inventory, what was the inventory turnover for last vear? What is the inventory turnover for this year? (0.2 points) 2) Has turnover improved this year? Calculate the percent change. (0.2 points) 3) What was the company's percentage of assets committed to inventory last year? What is the percentage of assets committed to inventory this year? (0.2 points) 4) How many weeks of finished goods were at hand at the end of last year? How much were at hand at the end of this year? (0.2 points) 5) Based on weeks of inventory, was there any improvement in the company's operations? Calculate the percent change and explain. (0.2 points) The plant manager at Track Technologies collected some performance metrics of his manufacturing facility. The table below shows the financial data available for last year and this year. Last year This year Sales $215,000 $228,000 Costs of goods sold $121,000 $131,000 Gross margin $94,000 $97,000 Net income $45,000 $48,000 Finished goods inventory $2,000 $5,000 WIP Inventory $10,000 $12,000 Raw Material Inventory $5,000 $6,000 Total inventory (avg/year) $17,000 $23,000 Other current assets $91,000 $110,000 Other assets $213,000 $242,000 Total Assets $321,000 $375,000 1) Based on the total inventory, what was the inventory turnover for last vear? What is the inventory turnover for this year? (0.2 points) 2) Has turnover improved this year? Calculate the percent change. (0.2 points) 3) What was the company's percentage of assets committed to inventory last year? What is the percentage of assets committed to inventory this year? (0.2 points) 4) How many weeks of finished goods were at hand at the end of last year? How much were at hand at the end of this year? (0.2 points) 5) Based on weeks of inventory, was there any improvement in the company's operations? Calculate the percent change and explain. (0.2 points)
Expert Answer:
Answer rating: 100% (QA)
1 Inventory turnover ratio Cost of goods sold Total Inventory 121000 17000 131... View the full answer
Related Book For
Applied Statistics in Business and Economics
ISBN: 978-0073521480
4th edition
Authors: David Doane, Lori Seward
Posted Date:
Students also viewed these accounting questions
-
The table below shows annual financial data for a sample of 20 companies in the food consumer products sector. Research question: At = .01, is there a significant correlation between revenue and pro...
-
Sales by quarter for last year and the first three quarters of this year were as follows: Using a procedure that you develop that captures the change in demand from last year to this year and also...
-
The table below shows key financial data for three firms that compete in the consumer products market: Procter & Gamble, Colgate-Palmolive, and Clorox. All dollar values are in thousands. a....
-
A decision maker is working on a problem that requires her to study the uncertainty surrounding the payoff of an investment. There are three possible levels of payoff $1,000, $5,000, and $10,000. As...
-
Claire Elise is not convinced that using activity-based costing techniques allows her to better control the costs in the HR department, so she asks the HR manager to estimate costs based simply on...
-
Improper double integrals can often be computed similarly to improper integrals of one variable. The first iteration of the following improper integrals is conducted just as if they were proper...
-
What are the functions of a condenser ?
-
The Grand Inn is a restaurant in Flagstaff, Arizona. It specializes in southwestern style meals in a moderate price range. Paul Weld, the manager of Grand, has determined that during the last 2 years...
-
The Executive Director (ED) of a North Philadelphia non-profit organization has been in place for the last 16 years. Many changes have occurred during this time. For example: more people come to work...
-
Use a time series chart to display the data shown in the table. The table represents the percentages of the U.S. gross domestic product (GDP) that come from the manufacturing sector. Organize the...
-
Information relating to actual costs and variances for year 2019 is shown below. The budgeted production for year 2019 was 42,000 products. Actual data Actual production 43,200 products Direct...
-
Identify a company with a published mission statement on its website. Evaluate its mission statement along each of the following criteria: a. Is the mission statement comprehensive? Is it concise? b....
-
Kelly Myers, a friend of yours, just told you an interesting story. She was at her parents house over the weekend and her father saw this book lying next to her backpack. He pickup it up and read...
-
Suppose that an oligopolist is charging $21 per unit of output and selling 31 units each day. What is its daily total revenue? Also suppose that previously it had lowered its price from $21 to $19,...
-
Phedre was working her first shift at the Hyacinth Burger Bar. She had gone through some training with the owner Melisande the previous day. She had found Melisande intimidating, despite her...
-
What is the formula for measuring price elasticity of demand? What does it mean (in terms of relative price and quantity changes) if the price-elasticity coefficient is less than 1? Equal to 1?...
-
What is the approximate yield to maturity of a 10% coupon rate, $1,000 par value bond which is currently priced at $1,200 with 11 years to maturity? What would be the yield to call if the call can be...
-
How does health insurance risk differ from other types of insurance risk (e.g., automobile or homeowners insurance)? What is the difference between cost sharing and cost shifting? Is retiree health...
-
Rates of return (annualized) in two investment portfolios are compared over the last 12 quarters. They are considered similar in safety, but portfolio B is advertised as being "less volatile." (a) At...
-
In the following regression, X = monthly maintenance spending (dollars), Y = monthly machine downtime (hours), and n = 15 copy machines. (a) Write the fitted regression equation. (b) State the...
-
The waiting time (in minutes) for emergency room patients with non-life-threatening injuries was measured at four hospitals for all patients who arrived between 6:00 and 6:30 p.m. on a certain...
-
Michael has his own consulting firm and works from home. He has the following expenses: Advertising, supplies, car expenses, computer, mortgage interest expense, real estate taxes, and utilities....
-
How would your answers change to Application Problem 8 if the transaction qualified as an excluded transaction? Problem 8 Chase would like to exchange land that he owns (adjusted basis \($140,000\)...
-
Jakari Smith is a new client and has been an investment advice provider as well as an income tax preparer for a well- established firm in the city. He would like to start his own firm as an S...
Study smarter with the SolutionInn App