Please fill out these tables

Case Overview The San Diego plant receives a purchase order from Silicon Valley Bikes for 60 red Professional Touring Bikes. After checking availability, the inventory manager realizes they don't have any in stock, so will need to order more from the Dallas plant. The Dallas plant currently doesn't have any in stock, so more must be produced. After checking availability of the components, the inventory manager in Dallas finds there is only one raw material with no stock, so it must be purchased. The raw material is received, the bikes are made, and they are shipped to the San Diego plant where they will be stored in inventory (San Diego has warehouse management active for finished goods). Later, the bikes are processed and shipped to Silicon Valley Bikes. This integration case is based on Chapter 9 section "Procurement, Fulfillment, Production and IWM Processes" on pages 332-346. Figure 9-23 on page 336 summarizes all the steps that will be required for the full project and the details about those steps. Create TO Confirm TO Warehouse management process FI Shipping (Delivery) COM FICO Shipping Billing (Goods issue) Payment Yes Stalt Customer PO Sales order processing Sufficient finished goods? Fulfillment process No Inventory management process San Diego: IM, Fulfillment, WM STO Goods receipt Create TR Create TO Confirm TO Warehouse management process FI Sufficient finished goods? Yes: Inventory management process Goods M issue (5) No Request production Authorize production Sufficient raw materials? COM Goods issue (components) FICOM Goods receipt Confirmation (Finished goods) Dallas: Production, Procurement, IM No --- Production process FI Create requisition Create & send purchase order M Receive shipment FI Receive Send invoice payment Procurement process . . The detailed explanations of the integration case are listed below: The San Diego plant (SDOO) receives a purchase order from Silicon Valley Bikes (SVB) for 60 Professional Touring Bikes (PRTR3099). The selling price is $3200 per bike without any discounts. However, you check the availability of the bikes and see that none are available. The inventory manager at San Diego places a stock transport order to get 80 bikes from Dallas plant (DLOO) (to have 20 in stock after fulfilling the sales order). The standard price in DLOO is $1500 per bike. Dallas just sent out a large shipment and has none left, so the bikes have to be produced. Production planning results in a planned order to produce 160 bikes. A quick check of the inventory in DLOO shows that all of the materials to make the Professional Touring Bike are available in DLOO except for the Touring Frame (TRFR3099), which will have to be purchased. You purchase 200 frames from Dallas Bike Basics (DBB) at the agreed upon price of $200 per unit. After receiving 200 frames, you use 160 frames to produce 160 Professional Touring Bikes in DLOO. Once they have been placed in the correct storage location, you send 80 of them to San Diego to fulfill the stock transport order. San Diego has warehouse management active for the finished goods storage location, so you will put them in a storage bin (STBN-7-099) for a few days. You pick 60 bikes out of the storage bin to ship them to Silicon Valley Bikes to fulfill the sales order. Finally, all vendor and customer accounts must be cleared using bank account. . . . . . . . . . 0 PART 1: Key Steps in Integration Case (40 pts) Based on the integration scenario, identify the key steps to be performed in SAP and complete the following table. You should indicate necessary information in each step, i.e., the amount of goods involved, and the code for materials. Use the following abbreviations in the table: SDOO - San Diego plant DLOO - Dalla plant SVB - Silicon Valley Bikes DBB - Dallas Bike Basics PRTR3099 Professional Touring Bikes PRTR3099 - Touring Frame PO - Purchase Order Pldord - Planned Order Prdord - Production Order STO - Stock Transport Order TO - Transfer Order In the table, you try to find out the steps to be performed in SAP instead of conceptual steps. So, you should refer to the previous SAP cases to identify the steps. Step SDOO DLOO 1 Create sales order for 60 PRTR3099 for SVB Not enough stock to fill the sales order; stock transfer starts 2 Create STO of 80 for Dallas Not enough stock to fill STO; production starts 3 Convert Pldord to Prdord for 160 PRTR3099 Not enough TRFR3099 for GI to prderd; procurement starts 4 . 5 6 Receive invoice from DBB & invoice verification 7 Production resumes 8 9 Confirm Prdord quantity of 160 PRTR3099 10 11 End of story for DLOO 12 13 14 Confirm TO of putawax of 80 PRTR3099 Sales resumes 15 16 17 Confirm TO for picking 60 PRTR3099 18 19 20 PART 2: IM & WM Results (20 pts) Indicate the stock level for the storage locations/status in DLOO and SDOO. Indicate the physical location of the material for warehouse management as well. If the value is 0, leave the cell blank. Your answers will be in red font. The following abbreviations are used in the table: . . PO - purchase order Prdord - production order STO-stock transport order TO-transfer order . Start GR from PO Gl to Prdord GR from Prdord GI to STO GR from Confirm TO STO for putaway Confirm TO for picking Post GI to SVB 0 80 20 0 SDOO IM FGOO (PRTR3099) In-transit (PRTR3099) WM 002 (Pallet) 003 (Receiving) 004 (Shipping) 0 0 0 DLOO IM FGOO (PRTR3099) RMOO (TRFR3099) 200 40 PART 3: Financial Impacts (30 pts) Identify the financial impacts of the integration case. Below is the summary of valuation for each material involved in the process. (Note: For the current purpose, disregard financial impacts of other factors, i.e., other raw materials, labor costs, overhead costs.) Professional Touring Bike (PRTR3099) Selling price: $3200 per bike Valuation in DL00/Valuation used in stock transfer from DLOO to SDOO: $1500 per bike . Profession Touring Frame (TRFR3099) Purchase price: $200 per frame (one frame needed to make one bike) Complete the following by specifying the step number (the number used in the first table) and the associated value. Step Step G/L Accounts Debit Credit no. no. 20 $192,000 Accounts Payable (AP) Accounts Receivable (AR) Bank Account Cost of Goods Sold (COGS) GR/IR Inventory-FG 11 $120,000 11 $120,000 5 $40,000 Inventory-RM Manufacturing Output Settlement RM Consumption Expense Revenue Case Overview The San Diego plant receives a purchase order from Silicon Valley Bikes for 60 red Professional Touring Bikes. After checking availability, the inventory manager realizes they don't have any in stock, so will need to order more from the Dallas plant. The Dallas plant currently doesn't have any in stock, so more must be produced. After checking availability of the components, the inventory manager in Dallas finds there is only one raw material with no stock, so it must be purchased. The raw material is received, the bikes are made, and they are shipped to the San Diego plant where they will be stored in inventory (San Diego has warehouse management active for finished goods). Later, the bikes are processed and shipped to Silicon Valley Bikes. This integration case is based on Chapter 9 section "Procurement, Fulfillment, Production and IWM Processes" on pages 332-346. Figure 9-23 on page 336 summarizes all the steps that will be required for the full project and the details about those steps. Create TO Confirm TO Warehouse management process FI Shipping (Delivery) COM FICO Shipping Billing (Goods issue) Payment Yes Stalt Customer PO Sales order processing Sufficient finished goods? Fulfillment process No Inventory management process San Diego: IM, Fulfillment, WM STO Goods receipt Create TR Create TO Confirm TO Warehouse management process FI Sufficient finished goods? Yes: Inventory management process Goods M issue (5) No Request production Authorize production Sufficient raw materials? COM Goods issue (components) FICOM Goods receipt Confirmation (Finished goods) Dallas: Production, Procurement, IM No --- Production process FI Create requisition Create & send purchase order M Receive shipment FI Receive Send invoice payment Procurement process . . The detailed explanations of the integration case are listed below: The San Diego plant (SDOO) receives a purchase order from Silicon Valley Bikes (SVB) for 60 Professional Touring Bikes (PRTR3099). The selling price is $3200 per bike without any discounts. However, you check the availability of the bikes and see that none are available. The inventory manager at San Diego places a stock transport order to get 80 bikes from Dallas plant (DLOO) (to have 20 in stock after fulfilling the sales order). The standard price in DLOO is $1500 per bike. Dallas just sent out a large shipment and has none left, so the bikes have to be produced. Production planning results in a planned order to produce 160 bikes. A quick check of the inventory in DLOO shows that all of the materials to make the Professional Touring Bike are available in DLOO except for the Touring Frame (TRFR3099), which will have to be purchased. You purchase 200 frames from Dallas Bike Basics (DBB) at the agreed upon price of $200 per unit. After receiving 200 frames, you use 160 frames to produce 160 Professional Touring Bikes in DLOO. Once they have been placed in the correct storage location, you send 80 of them to San Diego to fulfill the stock transport order. San Diego has warehouse management active for the finished goods storage location, so you will put them in a storage bin (STBN-7-099) for a few days. You pick 60 bikes out of the storage bin to ship them to Silicon Valley Bikes to fulfill the sales order. Finally, all vendor and customer accounts must be cleared using bank account. . . . . . . . . . 0 PART 1: Key Steps in Integration Case (40 pts) Based on the integration scenario, identify the key steps to be performed in SAP and complete the following table. You should indicate necessary information in each step, i.e., the amount of goods involved, and the code for materials. Use the following abbreviations in the table: SDOO - San Diego plant DLOO - Dalla plant SVB - Silicon Valley Bikes DBB - Dallas Bike Basics PRTR3099 Professional Touring Bikes PRTR3099 - Touring Frame PO - Purchase Order Pldord - Planned Order Prdord - Production Order STO - Stock Transport Order TO - Transfer Order In the table, you try to find out the steps to be performed in SAP instead of conceptual steps. So, you should refer to the previous SAP cases to identify the steps. Step SDOO DLOO 1 Create sales order for 60 PRTR3099 for SVB Not enough stock to fill the sales order; stock transfer starts 2 Create STO of 80 for Dallas Not enough stock to fill STO; production starts 3 Convert Pldord to Prdord for 160 PRTR3099 Not enough TRFR3099 for GI to prderd; procurement starts 4 . 5 6 Receive invoice from DBB & invoice verification 7 Production resumes 8 9 Confirm Prdord quantity of 160 PRTR3099 10 11 End of story for DLOO 12 13 14 Confirm TO of putawax of 80 PRTR3099 Sales resumes 15 16 17 Confirm TO for picking 60 PRTR3099 18 19 20 PART 2: IM & WM Results (20 pts) Indicate the stock level for the storage locations/status in DLOO and SDOO. Indicate the physical location of the material for warehouse management as well. If the value is 0, leave the cell blank. Your answers will be in red font. The following abbreviations are used in the table: . . PO - purchase order Prdord - production order STO-stock transport order TO-transfer order . Start GR from PO Gl to Prdord GR from Prdord GI to STO GR from Confirm TO STO for putaway Confirm TO for picking Post GI to SVB 0 80 20 0 SDOO IM FGOO (PRTR3099) In-transit (PRTR3099) WM 002 (Pallet) 003 (Receiving) 004 (Shipping) 0 0 0 DLOO IM FGOO (PRTR3099) RMOO (TRFR3099) 200 40 PART 3: Financial Impacts (30 pts) Identify the financial impacts of the integration case. Below is the summary of valuation for each material involved in the process. (Note: For the current purpose, disregard financial impacts of other factors, i.e., other raw materials, labor costs, overhead costs.) Professional Touring Bike (PRTR3099) Selling price: $3200 per bike Valuation in DL00/Valuation used in stock transfer from DLOO to SDOO: $1500 per bike . Profession Touring Frame (TRFR3099) Purchase price: $200 per frame (one frame needed to make one bike) Complete the following by specifying the step number (the number used in the first table) and the associated value. Step Step G/L Accounts Debit Credit no. no. 20 $192,000 Accounts Payable (AP) Accounts Receivable (AR) Bank Account Cost of Goods Sold (COGS) GR/IR Inventory-FG 11 $120,000 11 $120,000 5 $40,000 Inventory-RM Manufacturing Output Settlement RM Consumption Expense Revenue