Examlex
Use the case below to answer the following question(s) .
Rolling Inc.produces cars at two plants: Baltimore,Maryland,and Orlando,Florida.They ship them to major distribution centers in Minnesota,Dallas,Los Angeles,and Memphis.The Accounting,Production,and Marketing departments have provided the information in the table below,which shows the unit cost of shipping between any plant and distribution center to minimize the total transportation cost,not exceed available capacity,and meet customer demand. Suppose demand forecasts exceed the existing capacity and the company is considering adding a new plant from among two choices: Ohio or Kansas.Both plants would have a capacity of 3,000 units but only one can be built.The table below shows the revised data.
Use double-subscripted variables to simplify the formulation.Define Xij = amount shipped from plant i to distribution center j,where i = 1 represents Baltimore,and j = 1 represents Minnesota.
Define a binary variable for the decision of which plant to build: Y1 = 1 if the Ohio plant is built,and Y2 = 1 if the Kansas plant is built.
-If we are to use Solver to determine where the new plant has to be built,what is the amount shipped from Kansas to Memphis?
Materials Price Variance
The difference between the actual cost of materials and the standard cost, which can indicate inefficiencies or savings.
Direct Labor Rate Variance
The difference between the expected cost of direct labor at standard rates and the actual cost incurred.
Fixed Manufacturing Overhead
Costs that do not vary with the level of production output, including expenses such as factory rent, salaries of manufacturing personnel, and property taxes on manufacturing facilities.
Direct Labor Variances
The differences between the actual costs of labor and the standard or expected costs, used to assess how effectively labor resources are used.
Q21: Using Crystal Ball for the data set
Q24: The production of a popular line of
Q29: If two workers in the finishing department
Q68: The Extract Data in the Analyze group
Q74: What is a decision tree? Explain.
Q92: It is common for customers to leave
Q99: Jamal argues that poor nations rely too
Q102: Karl Marx believed that the working class
Q126: What income category do Nigeria,Cambodia,and Haiti belong
Q140: Subjective poverty is calculated by comparing a