The Good Time Wine Rack Company Background: The Production manager of the Good Time Wine Rack Company is retiring and the Managing Director is looking to replace her. You are preparing a work schedule as you are hoping to be offered the position of Production Manager, you know that the Managing Director is principally concerned with the budget. Feasibility of Schedule: You may end up with net loss by your schedule. Since it is on-going business, the loss on this week may be made up by operations on following weeks. So you do not need to worry about the loss. However, it is critical for you to have a feasible schedule. If your schedule is not feasible, then you may have your grade reduced by 30%. Submission Documents: You need to submit two documents: a case report and the Excel template file. Submit both files to the Canvas. The case report should include the approach to solve the project, the summary of your schedule, your total profit (or loss), and any comments, if necessary. The number of pages of the report should not exceed three. Introduction Welcome to the wine cellar business. As Production Manager of the Good Time Wine Rack Co., you supervise a small factory which builds custom bottle storage systems. These storage systems, or "wine racks", have been installed throughout the country. Your typical customer is a private wine collector, usually wealthy, who is either building or remodeling a wine cellar to store his or her own collection. Howard Stark, the owner of the Good Time Wine Rack Co., closes each deal personally and turns the order over to you to build. The order then becomes a "job" released into your factory, and is usually referred to by the name of the customer for whom it is being built. Howard promises that the job will be shipped by a certain date, although customers are happy to receive their cellars earlier, if possible. The Good Time Wine Rack Factory is a modest sized job shop located in an industrial park adjacent Canton, Ohio. You currently have four crew members staffing the factory: Steve Rogers (senior employee and master carpenter), Natasha Romanoff, Tony Stark (the son of your boss. Howard Stark), and Bruce Banner. Your job as Production Manager is to schedule the activities of these four employees, as well as keep them supplied with whatever materials they may need. BUILDING GROUNDPLAN (1/4 = 10 feet, approximately) 160 feet fence | Horizontal Piece Prep by Rip Cross Cut Cross Cut Lumber Storage Trim Production Horizontal Piece Prep Your Office 60 feet Rack Production Front Office Inspection and Packing To Street Loading Step Two: Rack Making: build ladder shaped subassemblies Step One: Part Making: Cut horizontal and vertical pieces Step three: Attach Horizontal Trim to assemble wine rack H eli Wine racks are made from clear-heart redwood, which is lumber cut from the center of a redwood tree. (Redwood is the preferred lumber of wine cellars, because it is highly mildew and insect resistant. Redwood gets its unique color from an acid which makes it unappetizing to most pests.) Individual racks consist of horizontal and vertical pieces fastened into ladder-shaped sub-assemblies, which are then held in place by horizontal bands of trim across the front and back of the rack. The wine racks pictured above are twenty-bottle high, single depth racks. Four columns of wine rack are visible in the break-away section of finished racking on the right. Note that attaching the horizontal trim in the third step above is not done in your production shop at the Good Time Wine Rack Company. Rather, the horizontal trim is created to order at your shop, and shipped separate from the ladder shaped sub-assemblies such as the one in the center of the picture. Step Three of this drawing is actually completed once all these items are delivered to the wine cellar location. If Step Three were completed in your shop, most finished wine racks would be too big to ship, and wouldn't fit through the door of the wine cellar even if they could be shipped. END OF THE WEEK INVENTORY LEVELS: You are only scheduling the shop for one week, but we imagine that somebody will have to pick up where you left off in the next week. (This is a simulation of an on-going operation. Therefore, there should be an award for leaving this person with some starting inventory. You earn $0.10 for every part you leave in inventory at the end of the week in excess of 2,040 parts. 2,040 is the total number of parts you started with. However, if you end with less than 2,040 parts in inventory, you will pay $0.20 for every part below the 2,040 benchmark. You earn $0.50 for every bottle space you leave in inventory at the end of the week in excess of 1,320 bottle spaces. 1,320 is the total number of bottle spaces you started with. However, if you end with less than 1,320 bottle spaces of racking in inventory, you will pay $1.00 for every bottle space below the 1,320 benchmark. The end of the week inventory level costs (or profit) will be automatically calculated in the Inventory Costs worksheet of the schedule template. IDLE TIME: If you idle someone you simply left the hour blank), you pay $100.00 for every idle hour. You are required to calculate accidental idle time costs using the above scheme. How to Calculate Total Profit (or Loss) Once you complete the schedule on the "Schedule Entry worksheet, net loss based on "inventory costs" and gain/loss from the "End of the week inventory levels" will be calculated automatically on the "Inventory Costs" worksheet. Calculate earnings/penalties based on your early/late shipments. Calculate penalties by having idle time. Consider the above gains/losses and calculate the final profit (or loss). The Good Time Wine Rack Company Background: The Production manager of the Good Time Wine Rack Company is retiring and the Managing Director is looking to replace her. You are preparing a work schedule as you are hoping to be offered the position of Production Manager, you know that the Managing Director is principally concerned with the budget. Feasibility of Schedule: You may end up with net loss by your schedule. Since it is on-going business, the loss on this week may be made up by operations on following weeks. So you do not need to worry about the loss. However, it is critical for you to have a feasible schedule. If your schedule is not feasible, then you may have your grade reduced by 30%. Submission Documents: You need to submit two documents: a case report and the Excel template file. Submit both files to the Canvas. The case report should include the approach to solve the project, the summary of your schedule, your total profit (or loss), and any comments, if necessary. The number of pages of the report should not exceed three. Introduction Welcome to the wine cellar business. As Production Manager of the Good Time Wine Rack Co., you supervise a small factory which builds custom bottle storage systems. These storage systems, or "wine racks", have been installed throughout the country. Your typical customer is a private wine collector, usually wealthy, who is either building or remodeling a wine cellar to store his or her own collection. Howard Stark, the owner of the Good Time Wine Rack Co., closes each deal personally and turns the order over to you to build. The order then becomes a "job" released into your factory, and is usually referred to by the name of the customer for whom it is being built. Howard promises that the job will be shipped by a certain date, although customers are happy to receive their cellars earlier, if possible. The Good Time Wine Rack Factory is a modest sized job shop located in an industrial park adjacent Canton, Ohio. You currently have four crew members staffing the factory: Steve Rogers (senior employee and master carpenter), Natasha Romanoff, Tony Stark (the son of your boss. Howard Stark), and Bruce Banner. Your job as Production Manager is to schedule the activities of these four employees, as well as keep them supplied with whatever materials they may need. BUILDING GROUNDPLAN (1/4 = 10 feet, approximately) 160 feet fence | Horizontal Piece Prep by Rip Cross Cut Cross Cut Lumber Storage Trim Production Horizontal Piece Prep Your Office 60 feet Rack Production Front Office Inspection and Packing To Street Loading Step Two: Rack Making: build ladder shaped subassemblies Step One: Part Making: Cut horizontal and vertical pieces Step three: Attach Horizontal Trim to assemble wine rack H eli Wine racks are made from clear-heart redwood, which is lumber cut from the center of a redwood tree. (Redwood is the preferred lumber of wine cellars, because it is highly mildew and insect resistant. Redwood gets its unique color from an acid which makes it unappetizing to most pests.) Individual racks consist of horizontal and vertical pieces fastened into ladder-shaped sub-assemblies, which are then held in place by horizontal bands of trim across the front and back of the rack. The wine racks pictured above are twenty-bottle high, single depth racks. Four columns of wine rack are visible in the break-away section of finished racking on the right. Note that attaching the horizontal trim in the third step above is not done in your production shop at the Good Time Wine Rack Company. Rather, the horizontal trim is created to order at your shop, and shipped separate from the ladder shaped sub-assemblies such as the one in the center of the picture. Step Three of this drawing is actually completed once all these items are delivered to the wine cellar location. If Step Three were completed in your shop, most finished wine racks would be too big to ship, and wouldn't fit through the door of the wine cellar even if they could be shipped. END OF THE WEEK INVENTORY LEVELS: You are only scheduling the shop for one week, but we imagine that somebody will have to pick up where you left off in the next week. (This is a simulation of an on-going operation. Therefore, there should be an award for leaving this person with some starting inventory. You earn $0.10 for every part you leave in inventory at the end of the week in excess of 2,040 parts. 2,040 is the total number of parts you started with. However, if you end with less than 2,040 parts in inventory, you will pay $0.20 for every part below the 2,040 benchmark. You earn $0.50 for every bottle space you leave in inventory at the end of the week in excess of 1,320 bottle spaces. 1,320 is the total number of bottle spaces you started with. However, if you end with less than 1,320 bottle spaces of racking in inventory, you will pay $1.00 for every bottle space below the 1,320 benchmark. The end of the week inventory level costs (or profit) will be automatically calculated in the Inventory Costs worksheet of the schedule template. IDLE TIME: If you idle someone you simply left the hour blank), you pay $100.00 for every idle hour. You are required to calculate accidental idle time costs using the above scheme. How to Calculate Total Profit (or Loss) Once you complete the schedule on the "Schedule Entry worksheet, net loss based on "inventory costs" and gain/loss from the "End of the week inventory levels" will be calculated automatically on the "Inventory Costs" worksheet. Calculate earnings/penalties based on your early/late shipments. Calculate penalties by having idle time. Consider the above gains/losses and calculate the final profit (or loss)