50.1K

Verified Solution

Link Copied!

Determine the total cost. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline 4 & A & B & c & D & E & F & G & H & 1 & j & K & L & M & N & 0 & P \\ \hline 1 & & & & & & & & \multicolumn{3}{|c|}{ Month Covered by Lease } & & & & & & \\ \hline 2 & Month of Lease: & 1 & 1 & 1 & 1 & 1 & 2 & 2 & 2 & 2 & 3 & 3 & 3 & 4 & 4 & 5 \\ \hline 3 & Length of Lease: & 1 & 2 & 3 & 4 & 5 & 1 & 2 & 3 & 4 & 1 & 2 & 3 & 1 & 2 & 1 \\ \hline 4 & Month 1 & 1 & 1 & 1 & 1 & 1 & & & & & & & & & & \\ \hline 5 & Month 2 & & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & & & & & & \\ \hline 6 & Month 3 & & & 1 & 1 & 1 & & 1 & 1 & 1 & 1 & 1 & 1 & & & \\ \hline 7 & Month 4 & & & & 1 & 1 & & & 1 & 1 & & 1 & 1 & 1 & 1 & \\ \hline 8 & Month 5 & & & & & 1 & & & & 1 & & & 1 & & 1 & 1 \\ \hline \multicolumn{17}{|c|}{9} \\ \hline 10 & Cost of Lease & $65 & $100 & $135 & $160 & $190 & $65 & $100 & $135 & $160 & $65 & $100 & $135 & $65 & $100 & $65 \\ \hline 11 & (per sq. ft.) & & & & & & & & & & & & & & & \\ \hline \multicolumn{17}{|c|}{12} \\ \hline \multicolumn{17}{|l|}{13} \\ \hline \multicolumn{17}{|l|}{14} \\ \hline 15 & & & & & & & & & & & & & & & & \\ \hline 16 & & & & & & & & & & & & & & & & \\ \hline \end{tabular} New Exercise Bank Content Qu. 06-13 Web Mercantile sells many household products through an online catalog. The company needs substantial warehouse space for storing its goods. Plans now are being made for leasing warehouse storage space over the next five months. Just how much space will be required in each of these months is known. However, since these space requirements are quite different, it may be most economical to lease only the amount needed each month on a month-by-month basis. On the other hand, the additional cost for leasing space for additional months is much less than for the first month, so it may be less expensive to lease the maximum amount needed for the entire five months. Another option is the intermediate approach of changing the total amount of space leased (by adding a new lease and/or having an old lease expire) at least once but not every month. The space requirement and the leasing costs for the various leasing periods are as follows. Click here for the Excel Data File The objective is to minimize the total leasing cost for meeting the space requirements. Formulate a spreadsheet model for this problem. Then use Solver to solve the model. Determine the total cost. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline 4 & A & B & c & D & E & F & G & H & 1 & j & K & L & M & N & 0 & P \\ \hline 1 & & & & & & & & \multicolumn{3}{|c|}{ Month Covered by Lease } & & & & & & \\ \hline 2 & Month of Lease: & 1 & 1 & 1 & 1 & 1 & 2 & 2 & 2 & 2 & 3 & 3 & 3 & 4 & 4 & 5 \\ \hline 3 & Length of Lease: & 1 & 2 & 3 & 4 & 5 & 1 & 2 & 3 & 4 & 1 & 2 & 3 & 1 & 2 & 1 \\ \hline 4 & Month 1 & 1 & 1 & 1 & 1 & 1 & & & & & & & & & & \\ \hline 5 & Month 2 & & 1 & 1 & 1 & 1 & 1 & 1 & 1 & 1 & & & & & & \\ \hline 6 & Month 3 & & & 1 & 1 & 1 & & 1 & 1 & 1 & 1 & 1 & 1 & & & \\ \hline 7 & Month 4 & & & & 1 & 1 & & & 1 & 1 & & 1 & 1 & 1 & 1 & \\ \hline 8 & Month 5 & & & & & 1 & & & & 1 & & & 1 & & 1 & 1 \\ \hline \multicolumn{17}{|c|}{9} \\ \hline 10 & Cost of Lease & $65 & $100 & $135 & $160 & $190 & $65 & $100 & $135 & $160 & $65 & $100 & $135 & $65 & $100 & $65 \\ \hline 11 & (per sq. ft.) & & & & & & & & & & & & & & & \\ \hline \multicolumn{17}{|c|}{12} \\ \hline \multicolumn{17}{|l|}{13} \\ \hline \multicolumn{17}{|l|}{14} \\ \hline 15 & & & & & & & & & & & & & & & & \\ \hline 16 & & & & & & & & & & & & & & & & \\ \hline \end{tabular} New Exercise Bank Content Qu. 06-13 Web Mercantile sells many household products through an online catalog. The company needs substantial warehouse space for storing its goods. Plans now are being made for leasing warehouse storage space over the next five months. Just how much space will be required in each of these months is known. However, since these space requirements are quite different, it may be most economical to lease only the amount needed each month on a month-by-month basis. On the other hand, the additional cost for leasing space for additional months is much less than for the first month, so it may be less expensive to lease the maximum amount needed for the entire five months. Another option is the intermediate approach of changing the total amount of space leased (by adding a new lease and/or having an old lease expire) at least once but not every month. The space requirement and the leasing costs for the various leasing periods are as follows. Click here for the Excel Data File The objective is to minimize the total leasing cost for meeting the space requirements. Formulate a spreadsheet model for this problem. Then use Solver to solve the model

Answer & Explanation Solved by verified expert

See Answer