DataSpan, Incorporated, implemented Lean Production and would like to redesign its performance measures accordingly. It hasprovided the following data sets:Percentage of on-time deliveriesTotal sales (units)Move time per unitProcess time per unitWait time per order before start of productionQueue time per unitInspection time per unitRequired 1Required 2Month 1Month 2Month 3Month 4285%80%2,180 2,087Required 3MonthComplete this question by entering your answers in the tabs below.Throughput Timedaysdaysdaysdays377%1,9801-a. Compute the throughput time for each month.1-b. Compute the delivery cycle time for each month.1-c. Compute the manufacturing cycle efficiency (MCE) for each month.Note: Round your answers to 1 decimal place.Delivery Cycle Timedaysdaysdaysdays< Required 1Required:1-a. Compute the throughput time for each month.1-b. Compute the delivery cycle time for each month.1-c. Compute the manufacturing cycle efficiency (MCE) for each month.2. Evaluate the company's performance over the last four months.3-a. Refer to the data for month 4. Assume in month 5 the company uses Lean Production to completely eliminate the queue time, andall else remains the same as month 4. Compute the new throughput time and MCE.3-b. Refer to the data for month 4. Assume in month 6 the company eliminates all queue time and inspection time, and all else remainsthe same as month 4. Compute the new throughput time and MCE.41,905Average per Month (in days)120.83.124.04.70.574%0.52.926.35.30.6Manufacturing CycleEfficiency (MCE)%%%%30.62.829.06.00.6Required 2 >0.62.631.46.80.5Show less A

Company performance refers to the judgment of the ability of the employees, efficiency of work done…

DataSpan, Incorporated, implemented Lean Production and would like to redesign its performance measures accordingly. It has provided the following data sets: Percentage of on-time deliveries Total sales (units) 85% 2,180 Month 3 2 77% 80% 2,087 1,980 74% 1,905 Average per Month (in days)

DataSpan, Incorporated, implemented Lean Production and would like to redesign its performance measures accordingly. It has provided the following data sets: Percentage of on-time deliveries Total sales (units) 85% 2,180 Month 3 2 77% 80% 2,087 1,980 74% 1,905 Average per Month (in days)

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: Markson Company had the following results of operations for the past year contribution margin income…

A: The decision to sell or not is calculated by measuring the incremental sales and cost.If the…

Q: Calip Corporation, a merchandising company, reported the following results for October: Sales Cost…

A: The difference between the sales and the variable costs is called contribution margin. Contribution…

Q: Northern, Inc. just finished its second year of operations. In the first year it produced 1,000…

A: Total production costs = Total Variable production costs + Fixed manufacturing overhead where, Total…

Q: For each year 2016 and 2017 Percentage of on-time deliveries

A: Percentage of On-time deliveries shows the percentage of goods or services delivered to the…

Q: The level of inventory of a manufactured product has increased by 6,980 units during a period. The…

A: Value of inventory under Variable costing = Increase in units of inventory x Variable manufacturing…

Q: Belmain Co. expects to maintain the same inventories at the end of 20Y7 as at the beginning of the…

A: Contribution margin = Sales - Variable costs Contribution margin ratio = Contribution margin / Sales…

Q: Most businesses sell several products at varying prices. The products often have different unit…

A: BREAKEVEN POINTBreak Even means the volume of production or sales where there is no profit or…

Q: Ayayai Inc. operates the Patio Furniture Division as a profit center. Operating data for this…

A: The responsibility report only includes those costs that can be affected by the decision of the…

Q: Whitman Company has just completed its first year of operations. The company's absorption costing…

A: Disclaimer: "Since you have asked multiple questions, we will solve the first question for you. If…

Q: Required: 1-a. Prepare contribution format segmented income statements for the total company broken…

A: A contribution format income statement provides a breakdown of a company's revenues, costs, and…

Q: Vulcan Company’s contribution format income statement for June is as follows: Vulcan Company…

A: Company Nothern Southern $ $ $ Sales 900000 500000 400000 Variable expenses 400000 200000…

Q: Crane Company reports the following operating results for the month of August: sales $378,000 (units…

A: Income statement is a financial statement that shows profitability, total revenue and total…

Q: Fiske Corporation manufactures a popular regional brand of kitchen utensils. Result sing the data of…

A: There are two type of costs incurred in business. One is fixed costs and another is Variable costs…

Q: Most businesses sell several products at varying prices. The products often have different unit…

A: It denotes the volume of sales or output at which a business makes a profit or loses money because…

Q: What impact would accepting this special order have on operating profit? b. Should RTD accept the…

A: A special order decision of acceptance the order is dependent upon the result of outcome of effect…

Q: Required: 1-a. Prepare contribution format segmented income statements for the total company broken…

A: The contribution format segmented income statements is the format on which the each segment of the…

Q: Most businesses sell several products at varying prices. The products often have different unit…

A: Break even point is the point at which there is no profit and no loss. Also at this point the…

Q: Barnes Company reports the following operating results for the month of August: sales $325,000…

A: Fixed costs are costs that remains constant and is not affected by the production or sale of output.…

Q: Most businesses sell several products at varying prices. The products often have different unit…

A: Break even point is that point of sales, where there is neither profit nor loss i.e. the company is…

Q: Blossom Company reports the following operating results for the month of August: sales $300,000…

A: Cost, volume, and, profit analysis:Cost, volume, and, profit analysis (CVP) analysis refers to the…

Q: The Consumer Products Division of Goich Corporation had average operating assets of $500.000 and net…

A: Minimum required return = Average operating assets × Minimum required rate of return

Q: Required information [The following information applies to the questions displayed below.] Henna…

A: Lets understand the basics. Break even point is a point at which no profit no loss condition arise.…

Q: Most businesses sell several products at varying prices. The products often have different unit…

A: It is that point of activity, where the contribution margin is equal to the fixed costs as a result…

Q: Vulcan Company's contribution format income statement for June is as follows: Vulcan Company Income…

A: Variable costs are costs that vary with the change in the level of output whereas fixed costs are…

Q: Cullumber Company reports the following operating results for the month of August: sales $300,000…

A: Net income is the amount of money earned by the entity after deducting the expenses from the…

Q: Crane Company reports the following operating results for the month of August: sales $392,000 (4,900…

A: Income statement is a financial statement that shows profitability, total revenue and total…

Q: Cullumber Farms reports the following results for the month of November: Sales (11,100 units)…

A: Based on these calculations, the first option (increasing selling price by 5%) results in the…

Q: Microsoft uses residual income to evaluate the performance of its divisions. The company's minimum…

A: Operating income: It is the revenue earned from day to day operational activities of the business…

Question

DataSpan, Incorporated, implemented Lean Production and would like to redesign its performance measures accordingly. It has
provided the following data sets:
Percentage of on-time deliveries
Total sales (units)
Move time per unit
Process time per unit
Wait time per order before start of production
Queue time per unit
Inspection time per unit
Required 1
Required 2
Month 1
Month 2
Month 3
Month 4
2
85%
80%
2,180 2,087
Required 3
Month
Complete this question by entering your answers in the tabs below.
Throughput Time
days
days
days
days
3
77%
1,980
1-a. Compute the throughput time for each month.
1-b. Compute the delivery cycle time for each month.
1-c. Compute the manufacturing cycle efficiency (MCE) for each month.
Note: Round your answers to 1 decimal place.
Delivery Cycle Time
days
days
days
days
< Required 1
Required:
1-a. Compute the throughput time for each month.
1-b. Compute the delivery cycle time for each month.
1-c. Compute the manufacturing cycle efficiency (MCE) for each month.
2. Evaluate the company's performance over the last four months.
3-a. Refer to the data for month 4. Assume in month 5 the company uses Lean Production to completely eliminate the queue time, and
all else remains the same as month 4. Compute the new throughput time and MCE.
3-b. Refer to the data for month 4. Assume in month 6 the company eliminates all queue time and inspection time, and all else remains
the same as month 4. Compute the new throughput time and MCE.
4
1,905
Average per Month (in days)
1
2
0.8
3.1
24.0
4.7
0.5
74%
0.5
2.9
26.3
5.3
0.6
Manufacturing Cycle
Efficiency (MCE)
%
%
%
%
3
0.6
2.8
29.0
6.0
0.6
Required 2 >
0.6
2.6
31.4
6.8
0.5
Show less A

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction :

VIEW

Step 2: Throughput Time-

VIEW

Step 3: Delivery Cycle Time For Each Month -

VIEW

Step 4: Manufacturing Cycle Efficiency (MCE) -

VIEW

Step 5: Company's Performance Over The Last Four Months -

VIEW

Step 6: Throughput Time And Manufacturing Cycle Efficiency For Month 5 -

VIEW

Step 7: Throughput Time And Manufacturing Cycle Efficiency For Month 6 -

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 8 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions

Please provide answer
Memofax Inc. produces memory enhancement kits for fax machines. Sales have been very erratic, with some months showing a profit and some months showing a loss. The company's contribution format income statement for the most recent month is given below. Sales (12,600 units at $40 per unit $504,000 Variable 202.40 *
accouting
According to the producer price index database maintained by the Bureau of Labor Statistics, the average cost of computer equipment fell 3.8 percent between January and December 2018. Let's see whether these changes are reflected in the income statement of Wizard Computers for the year ended December 31, 2018. 2018 2017 Sales Revenue $ 118,000 $ 147,000 Cost of Goods Sold 69,000 78,700 Gross Profit 49,000 68,300 Selling, General, and Administrative Expenses 37,800 40,600 Interest Expense 680 565 Income before Income Tax Expense 10,520 27,135 Income Tax Expense 2,500 6,800 Net Income $ 8,020 $ 20,335 Required: Compute the times interest earned ratios for 2018 and 2017. Does Wizard generate sufficient net income in both years (before taxes and interest) to cover the cost of debt financing? yes or no
Required information [The following information applies to the questions displayed below.] Hudson Company reports the following contribution margin income statement. HUDSON COMPANY Contribution Margin Income Statement For Year Ended December 31 Sales (11,200 units at $280 each) Variable costs (11,200 units at $210 each) Contribution margin Fixed costs Income $ 3,136,000 2,352,000 784,000 567,000 $ 217,000 1. Compute break-even point in units. 2. Compute break-even point in sales dollars. 1. Break-even units 2. Break-even sales dollars units
ulcan Company's contribution format income statement for June is as follows: Vulcan Company Income Statement For the Month Ended June 30 Sales Variable expenses Contribution margin Fixed expenses Net operating income $ 900,000 408,000 492,000 455,000 $ 37,000 Management is disappointed with the company's performance and is wondering what can be done to improve profits. By examining sales and cost records, you have determined the following: a. The company is divided into two sales territories-Northern and Southern. The Northern Territory recorded $400,000 in sales and $208,000 in variable expenses during June; the remaining sales and variable expenses were recorded in the Southern Territory. Fixed expenses of $164,000 and $125,000 are traceable to the Northern and Southern Territories, respectively. The rest of the fixed expenses are common to the two territories. b. The company is the exclusive distributor for two products-Paks and Tibs. Sales of Paks and Tibs totaled $150,000 and…
Bramble Company reports the following operating results for the month of August: sales $300,000 (units 5,000); variable costs $217,000; and fixed costs $70,000. Management is considering the following independent courses of action to increase net income.Compute the net income to be earned under each alternative.1. Increase selling price by 10% with no change in total variable costs or sales volume. Net income $enter a net income if the selling price is increased by 10% 2. Reduce variable costs to 55% of sales. Net income $enter a net income if the variable costs are reduced to 55% of sales 3. Reduce fixed costs by $18,000. Net income $enter a net income if the fixed costs are reduced by $18,000
Imagination Corporation uses residual income to evaluate the performance of its divisions. Imagination's minimum required rate of return is 10%. In April, the Commercial Products Division had average operating assets of $105,000 and net operating income of $9,700. What was the Commercial Products Division's residual income in April? Multiple Choice $970. $(970). $800. $(800).
During the current year, Mute Corporation expected to sell 24,300 telephone switches. Fixed costs for the year were expected to be $12,145,500, the unit sales price was budgeted at $3,350, and unit variable costs were budgeted at $1,560. Mute's margin of safety ratio (MOS %) is: (Do not round intermediate calculations.) Multiple Choice 72.07%. 87.82%. 71.07%. 93.32%. 76.97%.
Moses Moonrocks Inc. has developed a balanced scorecard with a measure map that suggests that the number of erroneous shipments has a direct effect on operating profit. The company estimates that every shipment error leads to a reduction of revenue by $6,000 and increased costs of about $4,000. Sales $227,000 Cost of goods sold 142,000 Depreciation expense 17,000 Other expenses 18,000 If the company has the above budgeted sales and costs for next month (without accounting for any possible shipping errors), determine how many shipping errors the company can afford to have and still break even. Break-even shipping errors : ?