supply chain analytics question

Project Description:

the two part question below is what i will need answered! it will need to be completed in excel, and if needed, you may have to use the solvertable in excel. if anyone is available that possesses the necessary skills to answer this question, i would be so grateful! thank you!

supply chain design muslin office furniture manufactures a popular line of filing cabinets and has a very strong competitive position in its market. the company sells its product to a number of wholesale distributors who, in turn, sell to retail customers. in this environment, the company faces a demand curve of the following form

q1 = 20 – 0.6p1

where p1 denotes its selling price and q1 denotes the volume (in thousands) sold at that price. muslin also experiences increasing marginal costs of the form 0.8q1. (this means that its total cost is 0.8(q1)2/2.) increasing marginal costs occur because of quality losses and congestion on the shop floor as volume rises.
one of muslin’s distributors is a subsidiary known as new england supply. they represent muslin’s exclusive distributor in the northeast, and the parent company allows them to operate as an independent entity, focused on distribution. they buy filing cabinets from muslin and sell them to retail customers in the northeast. in that market, new england supply faces its own demand curve as follows

q2 = 10 – 0.2p2

where p2 denotes the retail selling price and q2 denotes the volume (in thousands) sold in the northeast at that price. new england supply incurs its own operating costs, in addition to the cost of purchasing the product from muslin, so that its marginal cost function takes the form p1 + 0.4q2. this means that its total cost is p1q2 + 0.4(q2)2/2.

(a) suppose that muslin office furniture and new england supply each analyze their own pricing strategies separately. that is, muslin finds its profit-maximizing price. then new england supply, whose cost is influenced by muslin’s price, maximizes its own profits. what is each firm’s optimal price and how much profit is earned between the two companies?
(b) suppose instead that the two firms make coordinated decisions. in other words, they choose a pair of prices, one wholesale and one retail, aimed at maximizing the total profit between the two firms. what is each firm’s optimal price in this coordinated environment? how much profit is earned between the two companies?
Skills Required:
Project Stats:

Price Type: Fixed

Project Budget: $0 to $10
Total Proposals: 4
1 Current viewersl
57 Total views
Project posted by:


Proposals Reputation Price offered
  • 4.4
    84 Jobs 35 Reviews
    $50 in 2 Days
  • 4.9
    95 Jobs 45 Reviews
    $35 in 1 Day
  • 4.9
    367 Jobs 233 Reviews
    $40 in 12 Hours