Question: A retail chain operates five stores in different locations. The chain has collected the following information from each of its stores last month ( see
A retail chain operates five stores in different locations. The chain has collected the following information from each of its stores last month see the table below Additionally, the chain has indicated that:
$ in monthly corporate overhead fixed cost should be distributed evenly among the five stores ie $ each;
Labor cost per employee a month $;
Monthly rent cost per square foot of floor area $
Store Sales Revenue $ Number of Employees Floor Area sq ft Inventory Cost $
Store $ $
Store $ $
Store $ $
Store $ $
Store $ $
Q pts: Alice, the HR manager, is interested in evaluating labor productivity across stores for last month. Labor productivity is defined by Alice, using sales revenue as output and the number of employees as input. Identify the store with the best labor productivity and calculate its labor productivity rounded to five decimal places if not a whole number
Q pts: Bob, the financial analyst, aims to assess multifactor productivity across stores for last month. Multifactor productivity is defined by using sales revenue for output as well as labor cost, rent cost for the floor area, overhead expense, and inventory cost for inputs. Identify the store with the best multifactor productivity and calculate its multifactor productivity rounded to five decimal places if not a whole number
Q pts: The bottom line for the management is every store should at least achieve breakeven, meaning one dollar input cost generates at least one dollar revenue ie a multifactor productivity of at least If this bottom line was not met last month, the management plans to negotiate the rent for floor area with the landlord of these stores to sign a longer term lease because their lease expires very soon.
Assuming sale revenues and labor, inventory, and overhead costs for the near future will remain about the same as last month, calculate the threshold precise to the first decimal place of the monthly rent per square foot for floor area for meeting the above bottom line. That is as long as the floor rent is negotiated and lowered to this threshold rent, the above bottom line just starts to be met. If all stores met the above bottom line last month already, no calculation is needed and just answer NA below.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
