Inventory Part Code Product Description Category Supplier Price Unit Weight (g) In Stock On Backorder Reorder Reorder Qty Minimum Slock Level 10 FR1323 Nashbar Carbon Frame Frameset Nashbar $360 00 869 16 N FR1235 J L Fork Frameset Bikes Plus $213 40 312 9 Y Price Bracket Re order Amount FR2360 J L Plug Frameset Bikes Plus $11 18 6 3 N 0 50 FR1934 Headset Frameset Bikes Plus $0 00 49 8 26 N 5 25 FR1080 J L Top Cap Screw Frameset Cycle Warehouse $4 75 6 6 0 N 50 20 FR1081 Mr Ride Seat Clamp Frameset Cycle Warehouse $13 60 7 5 N 100 15 WH1100 XR 270 Bitex Wheel Wheels Cycle Warehouse $114 00 602 21 Y 200 10 WH2373 Veloplugs Rim tape Wheels LBS $4 62 3 1 1 Y WH2942 Titanium QR Skewers Wheels Cycle Warehouse $4 45 19 8 9 Y Supplier Part Codes on Backorder WH2856 Forte LCR Tyres Wheels Performance $21 83 149 3 20 N Backcountry WH1573 Forte Light Tubes Wheels Performance $4 73 45 4 4 N Bikes Plus CO2357 RockBros CrMo Saddle Contact Points Cycle Warehouse $18 63 151 2 7 N Cycle Warehouse CO1649 KCNC Scandium Seatpost Contact Points Cycle Warehouse $78 32 132 7 27 N LBS CO2143 Spacers Contact Points Bikes Plus $0 00 2 5 0 N Nashbar CO2202 Uno 7050 Stem Contact Points Cycle Warehouse $18 20 91 3 4 N Performance CO1099 Nashbar Carbon Bar Contact Points Nashbar $62 64 163 8 29 N CO1469 Generic Foam Tape Tape Contact Points Cycle Warehouse $0 15 0 4 7 N CO2904 Custom Bar Plugs Contact Points Cycle Warehouse $0 95 1 5 13 N GR2589 Ultegra Levers Groupset Nashbar $90 95 180 6 28 Y GR1322 Ultegra RD Groupset Backcountry $45 50 169 7 14 N GR1172 Ultegra FD Groupset Nashbar $26 39 63 2 18 N GR1836 Ultegra Cassette Groupset Nashbar $38 71 156 9 17 N GR1215 Dura Ace Chain Groupset Nashbar $29 44 157 6 22 Y GR1751 CNC brakes 200g Brakes Groupset Cycle Warehouse $63 75 72 14 N GR2009 Ultegra Cranks Groupset Nashbar $141 51 509 1 11 N GR1406 Ultegra BB Groupset Backcountry $16 32 55 4 18 N GR1550 Ultegra Cables Groupset Nashbar $0 00 37 8 3 N AC1508 Fairing M5 Bolts Accessories and tuning Cycle Warehouse $0 48 0 8 28 N AC1945 Alloy CR Bolts Accessories and tuning Cycle Warehouse $2 45 0 3 2 N AC2733 Titanium Stem Bolts Accessories and tuning Cycle Warehouse $11 28 8 1 10 Y AC2964 Generic FD Adapter Accessories and tuning Cycle Warehouse $2 28 14 8 N AC1914 Nashbar Alpe d Huez Pedals Accessories and tuning Nashbar $13 02 92 3 1 Y GR1432 Nashbar Levers Groupset Nashbar $96 00 172 1 21 N GR1770 Nashbar RD Groupset Nashbar $52 25 165 8 21 Y GR1966 Nashbar FD Groupset Nashbar $27 84 69 4 2 N GR2655 Nashbar Cassette Groupset Nashbar $36 90 159 5 N AC2170 RockBros S60 Pedals Accessories and tuning Cycle Warehouse $23 24 84 4 23 N WH1260 CNC V18 Ultra Wheels Wheels Cycle Warehouse $121 60 518 27 N WH2778 CNC V16 Super Slim Wheels Wheels Cycle Warehouse $154 80 567 8 15 Y CO1688 Specialised Foam Tape Tape Contact Points Cycle Warehouse $0 15 0 4 21 N Section F The following are to be completed in the Inventory Worksheet The inventory sheet contains a list of all items stocked to make the bikes The In Stock column indicates how many of each part are currently in stock Where the stock level has fallen below the minimum shown in M4 it may already have been re ordered, where this is the case a Y will show in the On Backorder Column Please note that all values in this sheet are subject to change and so cell references must be used rather than typing values into formulas F1 If a stock item falls below the minimum stock level in M4 and is not on backorder (value in column H is not Y ), then we need to reorder it In 15 create a calculation that will return Y if the item needs reordering and an empty string (nothing) if it does not F2 The quantity to reorder is determined by the price of the item as shown in the table in 17 M11, e g anything that costs between $5 and $50 we reorder 25, anything $200 and over we reorder 10 Note these values can change In J5 calculate the reorder quantity, return 0 if reorder not required F3 In M14 M19 calculate how many Part Codes are on Backorder for each supplier (in column LJ

The Answer is in the image, click to view ...

Question: Inventory Part Code Product Description Category Supplier Price/Unit Weight (g) In Stock On Backorder Reorder ? Reorder Qty Minimum Slock Level 10 FR1323 Nashbar Carbon

Inventory

Part Code

Product Description

Category

Supplier

Price/Unit

Weight (g)

In Stock

On Backorder

Reorder ?

Reorder Qty

Minimum Slock Level

FR1323

Nashbar Carbon Frame

Frameset

Nashbar

$360.00

869

FR1235

J&L Fork

Frameset

Bikes Plus

$213.40

312

Price Bracket

Re-order Amount

FR2360

J&L Plug

Frameset

Bikes Plus

$11.18

FR1934

Headset

Frameset

Bikes Plus

$0.00

49.8

FR1080

J&L Top Cap & Screw

Frameset

Cycle Warehouse

$4.75

6.6

FR1081

Mr. Ride Seat Clamp

Frameset

Cycle Warehouse

$13.60

100

WH1100

XR-270/Bitex Wheel

Wheels

Cycle Warehouse

$114.00

602

200

WH2373

Veloplugs Rim tape

Wheels

LBS

$4.62

3.1

WH2942

Titanium QR Skewers

Wheels

Cycle Warehouse

$4.45

19.8

Supplier

Part Codes on Backorder

WH2856

Forte LCR Tyres

Wheels

Performance

$21.83

149.3

Backcountry

WH1573

Forte Light Tubes

Wheels

Performance

$4.73

45.4

Bikes Plus

CO2357

RockBros CrMo Saddle

Contact Points

Cycle Warehouse

$18.63

151.2

Cycle Warehouse

CO1649

KCNC Scandium Seatpost

Contact Points

Cycle Warehouse

$78.32

132.7

LBS

CO2143

Spacers

Contact Points

Bikes Plus

$0.00

2.5

Nashbar

CO2202

Uno 7050 Stem

Contact Points

Cycle Warehouse

$18.20

91.3

Performance

CO1099

Nashbar Carbon Bar

Contact Points

Nashbar

$62.64

163.8

CO1469

Generic Foam Tape Tape

Contact Points

Cycle Warehouse

$0.15

0.4

CO2904

Custom Bar Plugs

Contact Points

Cycle Warehouse

$0.95

1.5

GR2589

Ultegra Levers

Groupset

Nashbar

$90.95

180.6

GR1322

Ultegra RD

Groupset

Backcountry

$45.50

169.7

GR1172

Ultegra FD

Groupset

Nashbar

$26.39

63.2

GR1836

Ultegra Cassette

Groupset

Nashbar

$38.71

156.9

GR1215

Dura Ace Chain

Groupset

Nashbar

$29.44

157.6

GR1751

CNC brakes 200g Brakes

Groupset

Cycle Warehouse

$63.75

GR2009

Ultegra Cranks

Groupset

Nashbar

$141.51

509.1

GR1406

Ultegra BB

Groupset

Backcountry

$16.32

55.4

GR1550

Ultegra Cables

Groupset

Nashbar

$0.00

37.8

AC1508

Fairing M5 Bolts

Accessories and tuning

Cycle Warehouse

$0.48

0.8

AC1945

Alloy CR Bolts

Accessories and tuning

Cycle Warehouse

$2.45

0.3

AC2733

Titanium Stem Bolts

Accessories and tuning

Cycle Warehouse

$11.28

8.1

AC2964

Generic FD Adapter

Accessories and tuning

Cycle Warehouse

$2.28

AC1914

Nashbar Alpe d Huez Pedals

Accessories and tuning

Nashbar

$13.02

92.3

GR1432

Nashbar Levers

Groupset

Nashbar

$96.00

172.1

GR1770

Nashbar RD

Groupset

Nashbar

$52.25

165.8

GR1966

Nashbar FD

Groupset

Nashbar

$27.84

69.4

GR2655

Nashbar Cassette

Groupset

Nashbar

$36.90

159

AC2170

RockBros S60 Pedals

Accessories and tuning

Cycle Warehouse

$23.24

84.4

WH1260

CNC V18 Ultra Wheels

Wheels

Cycle Warehouse

$121.60

518

WH2778

CNC V16 Super Slim Wheels

Wheels

Cycle Warehouse

$154.80

567.8

CO1688

Specialised Foam Tape Tape

Contact Points

Cycle Warehouse

$0.15

0.4

Inventory Part Code Product Description Category

Section F The following are to be completed in the Inventory Worksheet The inventory sheet contains a list of all items stocked to make the bikes. The In Stock column indicates how many of each part are currently in stock. Where the stock level has fallen below the minimum shown in M4 it may already have been re- ordered, where this is the case a "Y" will show in the On Backorder Column. Please note that all values in this sheet are subject to change and so cell references must be used rather than typing values into formulas. F1 If a stock item falls below the minimum stock level in M4 and is not on backorder (value in column H is not "Y"), then we need to reorder it. In 15 create a calculation that will return "Y" if the item needs reordering and an empty string (nothing) if it does not. F2 The quantity to reorder is determined by the price of the item as shown in the table in 17:M11, e.g. anything that costs between $5 and $50 we reorder 25, anything $200 and over we reorder 10. Note: these values can change. In J5 calculate the reorder quantity, return 0 if reorder not required. F3 In M14:M19 calculate how many Part Codes are on Backorder for each supplier (in column LJ

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 Accounting Questions!

Complete these by using cell references Section F 14 F1 3 F2 3 The following are to be completed in the Inventory Worksheet The inventory sheet contains a list of all items stocked to make the bikes....

Section 14 F1 3 3 F2 3 3 The following are to be compierea in the inventory worksheet The inventory sheet contains a list of all items stocked to make the bikes. The In Stock column indicates how...

please Section 14 F1 3 3 F2 3 3 The following are to be compierea in the inventory worksheet The inventory sheet contains a list of all items stocked to make the bikes. The In Stock column indicates...

Pls explain the function Inventory Inventory Management In Stock - On Backor Reorder Reorder- - to 2 2 18 Min Slock Level Max Slock Level Reorder At Reorder Due 20 40 22 40 Price Bracket Re-order...

A B D E F G H J K L M N Inventory Inventory Management In Stock On Backord Reorder? Reorder Weight (g 0.3 6 Category Accessories and tuning Groupset Wheels Min Slock Level Max Slock Level Reorder At...

B1: Go to the Inventory Sheet. This sheet contains a list of all the items the company keep in stock to build the bikes. Each part is identified by a unique part code. Convert the Range A3:J43 to a...

section E----start from E3 ULE 1 Section E C e the break even proti setore tax (it we hadn't rounded Break Even Units this should be 0) The following are to be completed in the Profit Volume Forecast...

The inventory manager prefers to wait until a certain number of parts require re- ordering before placing the orders. He has specified this value in M5 but does adjust it depending on production...

1.M4 shows the Maximum Stock Level. In N15:N20 calculate how many part codes are over-stocked for each supplier, remember that the value in M4 can change. please help, what is the excel formula in...

Please provide with excel formulas. Thank you Marks Done Question Section F F1 3 O Instruction The following are to be completed in the Inventory Worksheet If a stock item falls below the minimum...

A 1-kip force P is applied as shown to the piston of the engine system. Knowing that 2.5 AB = in. and BC = 10 in. , determine the couple M required to maintain the equilibrium of the system when (a)...

What are the effects on interest rates and output of expansionary fiscal policy in an open economy with fixed exchange rates?

What types of Alternate financial documentation can be used with self employed alt doc loan applications. Select one: a. BAS b. Bank statements for 6mths c. Accountants Letter/declaration d. Tax...

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....