Using exex Check the formulas for the other manufacturing tasks to ensure they are written correctly and that the worksheet can be easily updated later if any inputs change The inputs are the Production Rate, Unit, $ Hour, and Quantity Shoe Check that the formula to summarize the labor costs is correct, and modify as needed Description Production Rate Unit $ Hour Delivery of Boxes to Product line 14 boxes hr 11 Cutting of Leather 20 shoes hr 20 50 Attachment of Appliques 30 appliques hr 10 Sewing of Logos to Leather 16 5 pieces hr 16 0 Assembly of Leather Sole 10 shoes hr 16 Assembly of Arch Support 18 5 shoes hr 10 89 Each Shoe Manufacturing Tasks Quantity Shoe Unit Total Cost Delivery of Boxes to Product line 25 boxes shoe DIV 0 Cutting of Leather 1 shoe 1 Attachment of Appliques 6 appliques shoe 2 Assembly of Leather Sole 1 00 shoe Assembly of Arch Support 1 00 shoe 0 0050 Total Labor DIV 0

Question: Using exex Check the formulas for the other manufacturing tasks to ensure they are written correctly and that the worksheet can be easily updated later

Using exex Check the formulas for the other manufacturing tasks to ensure they are written correctly and that the worksheet can be easily updated later if any inputs change. The inputs are the Production Rate, Unit, $/Hour, and Quantity/Shoe. Check that the formula to summarize the labor costs is correct, and modify as needed.

Description	Production Rate	Unit	$/Hour
Delivery of Boxes to Product line	14	boxes/hr	11
Cutting of Leather	20	shoes/hr	20.50
Attachment of Appliques	30	appliques/hr	10
Sewing of Logos to Leather	16.5	pieces/hr	16.0
Assembly of Leather & Sole	10	shoes/hr	16
Assembly of Arch Support	18.5	shoes/hr	10.89

Each Shoe - Manufacturing Tasks:	Quantity /Shoe	Unit	Total Cost
Delivery of Boxes to Product line	.25	boxes/shoe	#DIV/0!
Cutting of Leather	1	shoe	1
Attachment of Appliques	6	appliques/shoe	2
Assembly of Leather & Sole	1.00	shoe	######
Assembly of Arch Support	1.00	shoe	0.0050
Total Labor			#DIV/0!

Step by Step Solution

★★★★★

3.37 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Solution Question 5 Cli... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Discuss what HR managers can do to ensure they are hiring ethical employees.

Problem 23-7A Your answer is partially correct. Try again. Rogen Corporation manufactures a single product. The standard cost per unit of product is shown below. Direct materials-3 pound plastic at...

Sole Brother Inc. is a shoe outlet to a major shoe manufacturing industry located in Chicago. Sole Brother uses accounts payable as one of its financing sources. Shoes are delivered to Sole Brother...

using exex Check the formulas for the other manufacturing tasks to ensure they are written correctly and that the worksheet can be easily updated later if any inputs change. The inputs are the...

WEEK # 2 - EXERCISE CHAPTER # 1 - LEVEL 1 - B 5. Correct the formula in cell D10 so that it accurately calculates the cost of delivering boxes for one shoe. 6. Check the formulas for the other...

Whit the assistance of the manufacturing group, the product design team has prepared another worksheet that list the labor cost involved in manufacturing the TZEdge shoe. Description : Production...

With the assistance of the manufacturing group, the product design team has prepared another worksheet that lists the labor costs involved in manufacturing the TZEdge shoe. Figure 1.11 shows this...

especially if you In the next level, you will learn a more efficient way to build formulas that ensures accuracy when you need to update or change the formulas or cell references they include Steps...

Exercise 1 B: Level 1 - Labor Costs Objective: Correct errors in formulas and format With the assistance of the manufacturing group, the product design team has prepared another worksheet that lists...

i put all the questions first and after the file associated 1. Open the workbook named Labor.xlsx located in the Chapter 1 folder, and then save the file as Labor Costs.xlsx 2. Adjust the column...

Twenty-five independent polls of one thousand random people each are taking during the course of an extremely close election campaign. People in the poll are asked which of the two candidates they...

Renee Corporation has the following stockholders equity information: Retained earnings is $1,837,000, and the cost of treasury shares is $1,200,000. Required: Prepare the stockholders equity portion...

13.22 Find current I o in the circuit of Fig. 13.91. -50 HH 120 J400 m 160 m /10 2 1302 50/0 V (+ 180 100

The Grinch sneaks into a room with 6 Christmas presents to 6 different people. He proceeds to switch the name-labels on the presents. How many ways could he do this if (a) No present is allowed to...

1. PIMCO Equity Fund has a 3% load. Annual fees are 0.35%, and the expected average annual return for the next 7 years is 11% annually Vanguard Equity Fund is a no-load fund. Its expected average...

Case Study 1 You are a Midas Investment Services specialist in housing planning. You give lectures to various groups for a year about housing planning. You ask for a non-profit group (church, etc.)...

A psychologist studied self-esteem scores and found the data set to be normally distributed with a mean of 50 and a standard deviation of 6. Part A**What raw score cuts off the bottom 33% of this...

1. Consider the cognitive sequence and perspective on motivation. Using information from your text and outside reading you have completed, support your idea of what causes so many weight-loss plans...

can you tell me the correct answer? A seminomadic settlement pattern found among gathering-hunting bands like the Hadza of Tanzania involves all of the following except: C) Seasonal migrations from...

im so confused please help i included ALL of the instructions given. which part is insufficent, i will add more B D F G H 2 E Flexible Budget Performance Report Project 3 4 Kristin's Frozen...

Please post the formulas! Flexible Budget Performance Report Project Upload your completed project to Blackboard using "Flex Budget_Last Name_TA" as the file name. Kelsey's Frozen Confectionaries...

ALL ALL FORMULAS MUST BE SHOWN 1) Use the budget assumptions, along with Excel formulas, to populate the Master Budget column. Note: Your formulas must work such that if ANY of the budget assumptions...

This is for requirement 2 A B C D E F G H - J L M N Name: G#: 1 Chapter 5: Applying Excel 2 3 Data 4 Unit sales 5 Selling price per unit 6 Variable expenses per unit 7 Fixed expenses 20,000 units $60...

Flexible Budget Performance Report Project Kelseys Frozen Confectionaries buys and distributes single-serve ice cream treats, popsicles, etc., such as those sold at convenience stores, sporting...