Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The worksheet FabricCosts.xisx contains an estimate of the costs for making a red silk dress. Each of the material components and unit costs has been

image text in transcribed
image text in transcribed
image text in transcribed
The worksheet FabricCosts.xisx contains an estimate of the costs for making a red silk dress. Each of the material components and unit costs has been entered into the worksheet. However, there are several problems that need to be corrected before this worksheet is complete. Answer the questions within the sheet in the corresponding colored cells and/or make corrections as described below: 1. What is the problem with cell D2? Explain it in the yellow shaded area provided below the 2. If cell E2 contains the formula B2 D2 and it is copied down through cell E6, why does cell E6 display 3. what precise value is stored in cell!? Place your answer ("precise value is: ".) in the orange cells 4. Name the cell J1 shipping. In cell E8 write a formula to calculate the shipping cost assuming shipping spreadsheet. Correct the problem. the value 0? Place your answer in the blue cells adjacent to the question. adjacent to the question. is estimated at 10% of total costs. Use your named range. Format as currency. (put this directly cell E8) 5. What is the problem with cells F3:F6? Correct the formula in cell F2 and copy it down. Place your answer in the pink cells adjacent to the question. 6. A Chinese company has offered to supply and ship all of these materials for $46. In cell F10 is a calculation for the percent difference between the price you calculated and the price the Chinese offered. The percent difference is the difference in costs (new costs less the original costs including shipping) divided by the original cost. Is the formula correct? Why or why not? Place your answer (including correct formula if needed) in the bright green cells in area below. Copy the contents of cell E7 to cell K1. .. What value will result and why? Place your answer in the tan cells adjacent to the question. 7

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

Database Security And Auditing Protecting Data Integrity And Accessibility

Authors: Hassan A. Afyouni

1st Edition

0619215593, 9780619215590

More Books

Students also viewed these Accounting questions

Question

Understand the iterative nature of the public policy process

Answered: 1 week ago

Question

Describe the concept of diversity.

Answered: 1 week ago

Question

Summarize forecasting human resource availability.

Answered: 1 week ago