Shelby Shelving Company Essay Help

The purpose of this analysis is to maximize profit of Shelby Shelving Company manufacturing two types of shelves for grocery stores; Model S (standard model) and Model LX (heavy duty model). The plant?s engineer suggested that Model S manufacturing should be cut off as they are sold less than their manufacturing cost. On contrary the controller argued that Model S products absorb a large manufacturing overhead burden so even though they are sold at loss their manufacturing should continue. The analysis is performed by given accounting and production data for Shelby Company. Looking at particular data at firstShelby Shelving Company glance decreasing Model S production and increasing Model LX production seems to be feasible as unit profit for Model S is less than that of Model LX. However a rigorous analysis performed by Microsoft Excel with Solver Add-in indicated that for maximum profit increasing production of model S to its assembly capacity limit. The rationale behind this result is that Model S has lower direct material direct labour cost and variable overhead cost than Model LX so producing more Model S will allow company to compensate fixed assembly cost better. As a result increasing Model S production up to its assembly capacity and determining production of Model LX based on constraints gives us best solution. Therefore the argument of the controller is more reasonable than that of the plant?s engineer. MODELLING Assumptions a) All of the products are sold. b) Selling prices of Model S and Model LX are constant and cannot be changed as a result of competition. c) There are no machine breakdowns or out of operation periods so hour spent in stamping and forming departments are constant for respective products. d) Direct material cost (per unit) direct labour cost (per unit) fixed overhead costs (per unit) and variable overhead costs per unit e) There are no advance payments received for delivering products later on so quantities of products are non-negative. Decision Variables a) Current monthly production of Model S b) Current monthly production of Model LX Objective Maximize the profit Constraints a) The hours spent in departments must not exceed the available stamping and forming labor hours. b) The monthly production must not be greater than the assembly capacity of the plant. Algebraic Model Objective: MAX { ((PS*QS ? PS*VCS) ? FC) + ((PLX*QLX ? PLX*VCLX) ? FC) }; Constraints: a) Stamping:0.3*Qs + 0.3*QLX”

Welcome to Vision Essays! For over 10 years we have been helping students like you write, research, and generate ideas for their research papers, essays, term papers, dissertations, editing, resumes, and any other type of work your learning institution may assign you.

We can write any paper and have flexible payment plans with a minimum deadline of 6 Hrs.

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total: