Alignment Number A R F M N D G GBI management is seriously considering marketing a ruggedized version of their Touring Bike to "City Bike" bicycle rental programs. As a pilot, they have agreed to sell 30 City Bikes to a Dearborn-based start-up at a 10% discount off the usual price of $1000 per bike. Because this same bike design was previously offered on Ger's website as the poorly-selling Urban Delivery Bike, the material master data already exists in SAP and all of the raw materials needed to assemble the 30 City Bikes are already in Inventory. The raw materials to build one City Bike have a moving average cost of $448.25. 3 O Planned costs for the order were based on 60 minutes of labor at the Night Shift rate of $50/hour. However, because the City Bikes are a little trickier to assemble than the children's bikes usually built on the Night Shift, the plant manager chose to hold the Day Shift over and pay the Overtime rate of $75/hour. Day Shift was able to complete the assembly of the City Bikes in 55 minutes/Bike Steps How did you calculate the amount? 1. GI to production order 4 2. Goods receipt from production 5 3. Production order settlement 6 4. Shipping 7 5. Billing 8 6. Customer Payment 9 10 You will find it useful to calculate the variances: Bike-Share Bicycle Planned Actual Target Variance Big Hint: For the Production steps (Steps 1 to 3) see slides 6,7 11 [Estimate) (debit Icredit) (debit-credit) and 8 for Accounts 4 Video Production for the Pullment 12 Material steps (Steps 4, 5 and 6) see side 9 for TAccounts 3 Video 13 Labor Fulfillment 14 Total 0 0 15 16 Two of the account names and one subledger name have been provided. You will need to fill in the rest. You can add more accounts if you need them. 17 GENERAL LEDGER 19 Account Amount Account 20 21 22 Account 23 Account Account Me Output Settlement 24 25 26 Mfg Outout Settlement Account Account Variance 27 Account 28 29 30 Account Account 31 Account 16 Two of the account names and one subledger name have been provided. You will need to fill in the rest. You can add more accounts if you need them. 17 GENERAL LEDGER 19 Account Account Account 20 21 22 23 Account Account Account Me Output Settlement 24 25 26 Mig Output Settlement 27 Account Account Variance Account 28 29 30 31 Account Account Account 32 33 34 35 SUBLEDGERS 50 Account Account Customer-UM Dearborn Account 37 38 39 40 Extra Credit Essay 41 Question: (1 point) What would the Total Variance have been if the actual quantity produced had been 40 bikes instead of 30? 42 Your answer 43 45 46 47 Alignment Number A R F M N D G GBI management is seriously considering marketing a ruggedized version of their Touring Bike to "City Bike" bicycle rental programs. As a pilot, they have agreed to sell 30 City Bikes to a Dearborn-based start-up at a 10% discount off the usual price of $1000 per bike. Because this same bike design was previously offered on Ger's website as the poorly-selling Urban Delivery Bike, the material master data already exists in SAP and all of the raw materials needed to assemble the 30 City Bikes are already in Inventory. The raw materials to build one City Bike have a moving average cost of $448.25. 3 O Planned costs for the order were based on 60 minutes of labor at the Night Shift rate of $50/hour. However, because the City Bikes are a little trickier to assemble than the children's bikes usually built on the Night Shift, the plant manager chose to hold the Day Shift over and pay the Overtime rate of $75/hour. Day Shift was able to complete the assembly of the City Bikes in 55 minutes/Bike Steps How did you calculate the amount? 1. GI to production order 4 2. Goods receipt from production 5 3. Production order settlement 6 4. Shipping 7 5. Billing 8 6. Customer Payment 9 10 You will find it useful to calculate the variances: Bike-Share Bicycle Planned Actual Target Variance Big Hint: For the Production steps (Steps 1 to 3) see slides 6,7 11 [Estimate) (debit Icredit) (debit-credit) and 8 for Accounts 4 Video Production for the Pullment 12 Material steps (Steps 4, 5 and 6) see side 9 for TAccounts 3 Video 13 Labor Fulfillment 14 Total 0 0 15 16 Two of the account names and one subledger name have been provided. You will need to fill in the rest. You can add more accounts if you need them. 17 GENERAL LEDGER 19 Account Amount Account 20 21 22 Account 23 Account Account Me Output Settlement 24 25 26 Mfg Outout Settlement Account Account Variance 27 Account 28 29 30 Account Account 31 Account 16 Two of the account names and one subledger name have been provided. You will need to fill in the rest. You can add more accounts if you need them. 17 GENERAL LEDGER 19 Account Account Account 20 21 22 23 Account Account Account Me Output Settlement 24 25 26 Mig Output Settlement 27 Account Account Variance Account 28 29 30 31 Account Account Account 32 33 34 35 SUBLEDGERS 50 Account Account Customer-UM Dearborn Account 37 38 39 40 Extra Credit Essay 41 Question: (1 point) What would the Total Variance have been if the actual quantity produced had been 40 bikes instead of 30? 42 Your answer 43 45 46 47
