Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

what is this excel formula for the following blue blanks using this inventory page? fix F13 A B C D E F G J K

image text in transcribedwhat is this excel formula for the following blue blanks using this inventory page?

image text in transcribed

fix F13 A B C D E F G J K L M N 1 Futura Robotics Pty Ltd 4971 Job No. 2 3 4 Swissa Manufacturing 02/09/2019 15/09/2019 Customer Date Started 5 288 William Street, Brookvale, 2100 Date Finished 6 7 Job Detail 3 x Robotic Welders 8 Specs Customer No: As per detailed drawings, specifications C463241 10 11 DIRECT MATERIALS Item Code Details/Description 12 Quantity Date Department Req.No. Cost 14/9/19 14/9/19 14/9/19 14/9/19 13 225 S1010 Assembly 3 #NAME? 14 #NAME? Assembly 225 S1009 15 Assembly #NAME? 225 S1014 4 16 #NAME Assembly 228 R1024 2 8/9/19 18 R1004 M1021 #NAMEE #NAME 17 224 3 3 Assembly Programming 5/09/2019 223 19 20 Total Cost Direct Materials 21 22 23 DIRECT LABOUR Details/Description Installation of robots Final assembly in frame and finishing Re-programming Change design request Installing robot kit and servos Programming MGX 8025 Chip Set Design, blueprints and specifications prepared Department Engineering Assembly Programming Engineering Assembly Programming |Engineering 24 Date Time No. Hours Rate Cost 16/9/19 14/9/19 11/9/19 9/9/19 8/9/19 5/9/19 25 32 1028 26 A388 32 27 P227 21 28 1026 30 29 386 15 30 P225 17 2/9/19 31 1024 21 32 33 Average Hourly Rate Total Cost Labour 34 35 MANUFACTURING OVERHEAD Department Assembly Engineering Programming 36 Month September September 39 Application method Direct labour hours Cost Hours 37 Direct labour hours Direct labour hours 38 September 40 41 42 Total Manufacturing Overhead 43 44 SUMMARY 45 Total Cost 46 Quoted Price 47 GP Percent 40 49 51 52 Completed Jobs Overview Information Stats Inventory JOB_4971 Journals + VfxMGX 8025 Chip Set B5 E A C F G H J K L M Inventory Re-Order % Markup In Stock Reorder Qty Code Description On Back order Cost Price (each) Retail Price Over-Stocked 28% Connector Pack $80.26 $153.22 Maximum Stock Leval C1019 0 Yes $62.70 50 25 M1021 MGX 8025 Chip Set MGX 8066 Chip Set Robot Motor Kit $119.70 0 Yes 35 Minimum Stock Level 5 No. Item Codes to re-order MI022 36 $158.40 $202.75 Yes 7 No. Item Codes Over-Stocked $1,794.05 $3,018.75 $3,347.20 $3,766.66 $3,943.04 R1001 0 Yes $1,401.60 5 Robot Kit 33A. Robot Kit 38A Robat Kit 38G R1002 6 $2,358.40 Total Inventory Value $741,701.60 R1003 $2,615.00 Yes 5 R1004 0 $2,942.70 Yes 5 Reorder Quantities 1 R1005 2 R1006 3 R1007 R1023 Robot Kit SP3 Item Cost $0 $100 $300 $500 $1,000 S3,080.50 $3,186.60 Re-Order Qity 9 Robot Kit 448 $4,078.85 12 50 Robot Kit 555 Relays Smoll Pack Relays Medium Pack Relays Large Pack Servo Motors A21 (4 pack) Servo Motors B21 (4 pack) Servo Motors A21 (8 pack Serve Motors B21 (8 pack) SMC Pneumatic Part 3-44 SMC Pneumaric Part X-22 SMC Pneumatic Part X-335 SMC Pneumatic Part 3-47 SMC Pneumatic Part 3-48 SMC Pneumarie X 200mm SMC Pneumatic X 250mm SD Drive emc Connector Pace eme MGX 8025 Chip Set emc MGX 8066 Chip Set emc Robot Motor Kit emc Robot Kit 33A $4,256.26 0 14 S3,325.20 35 9 $248.00 $317.44 $400,90 20 5 R1024 12 $313.20 0 10 R1025 0 $332.50 $425.60 Yes 20 7 $1008 851009 s896.10 $1,147,01 $1,332.48 $2,419.20 $2,58560 $775.42 Yes 10 S1,041.00 S1,890.00 $2,020.00 S605.80 $732.90 0 Yes 5 S1010 3S 0 Yes S1011 Yes 5 1 51012 2 S1013 3 S1014 451015 5 51016 C Yes 10 0 Yes $938.11 $1,109.50 $1,043.71 $1,032.58 10 $866.80 11 s815.40 $806.70 $604.80 $623.10 $95.60 14 0 Yes 10 S1017 7 S1018 851020 c1219 9 S774.14 0 10 $797.57 $122.37 $93.44 12 16 $73.00 M1221 $118.40 $142.60 $151.55 1 M1222 2 R1201 3 R1202 4R1203 5 R1204 0 S182.53 Yes 35 S1,372.40 $2,381.70 $2,353.50 S2,885.00 0 $1,756.67 Yes 5 $3,048.58 $3,012.48 8 emc Robot Kit 38A 24 0 emc Robot Kit 38G emc Robot Kit SP3 $3,692.80 $3,78688 $4,078.85 $4,214.53 24 24 0 R1205 $2,958.50 $3,186.60 S3,292.60 $248.00 7R1206 B R1207 R1223 eme Robot Kit 448 emc Robot Kit 555 emc Relays Small Pack eme Relays Medium Pack emc Relays Lorge Pack emc Servo Motors A21 (4 pack) amc Servo Moters B21 (4 pack) emc Servo Motors A21 (8 pack) emc Servo Motors B21 (8 pack) emc SMC Pneumatic Part 3-44 27 Yes 18 1 Yes S317.44 35 $412.29 $396 42 10 $322.10 R1224 1R1225 2 S1208 3 S1209 $309.70 S1,030.90 $959.40 27 Yes 24 $1,319.55 $1,228.03 $2,464.00 $2,508.80 7 4 S1210 1 $1,925.00 S1,960.00 Yes 5 S1211 $1212 7 51213 B 51214 S1215 22 $792.32 S854.53 2 24 Yes $619.00 10 eme SMC Pneumatic Pat X-22 $467.60 $717.10 emc SMC Pneumatic Part X-33 emc SMC Pneumatic Part 3-47 ame SMC Pneumotic Part 3-48 emc SMC Pneumatic X 200m emc SMC Pneumatic X 250mm emc SD Drive 3 S917.89 Yes 10 1d $807.90 $1,034.11 0 S1216 $782.70 $515.20 $1,001.86 10 Yes 1 51217 2 51218 3 S1220 S659.46 0 11 $623.10 S797.57 $88.00 16 $112.64 0 Overview Information Completed Jobs Stats Inventory JOB_4971 Journals +

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

Students also viewed these Accounting questions

Question

2. What efforts are countries making to reverse the brain drain?

Answered: 1 week ago