Question

In: Statistics and Probability

Crombie supermarket sells its own private label of canned peas as well as other national brands....

Crombie supermarket sells its own private label of canned peas as well as other national brands. The store makes a profit of $0.28 per can for its private label peas and a profit of $0.19 for any of other brands. The store has 6 square feet of shelf space available for canned pas, and each can of peas takes up 9 square feet of that space. Analytics show that each week the store sells less than half as many cans of its private label brand as it does the other national brands. The store wants to know how many cans of its own brand of peas and how many cans of the other brands to stock each week on the allocated shelf space in order maximize profits. a) formulate the problem of algebraically a linear programming model for this program. b) Solve this problem using excel.

Solutions

Expert Solution

There is a discrepancy in the question, the amount of space occupied by each can should be 9 squares inches. Total space of 6 square feet and 9 square feet per can makes no sense, you cannot fit even one can in that case

Now total cans that can be accomodated are

Problem Formulation

Constraints

Objective Function

Excel Output

Initialization

Solution


Related Solutions

A study showed that 62% of supermarket shoppers believe supermarket brands to be as good as national name brands.
  A study showed that 62% of supermarket shoppers believe supermarket brands to be as good as national name brands. To investigate whether this result applies to its own product, the manufacturer of a national name-brand ketchup asked a sample of shoppers whether they believed that supermarket ketchup was as good as the national brand ketchup. (a) Formulate the hypotheses that could be used to determine whether the percentage of supermarket shoppers who believe that the supermarket ketchup was as...
Pastina Company sells various types of pasta to grocery chains as private label brands.
Pastina Company sells various types of pasta to grocery chains as private label brands. The company's fiscal year-end is December 31. The unadjusted trial balance as of December 31, 2016, appears below.       Account Title Debits Credits   Cash 30,000        Accounts receivable 40,000        Supplies 1,500        Inventory 60,000        Note receivable 20,000        Interest receivable 0        Prepaid rent 2,000        Prepaid insurance 0        Office equipment 80,000        Accumulated...
Pastina Company sells various types of pasta to grocery chainsas private label brands. The company's...
Pastina Company sells various types of pasta to grocery chains as private label brands. The company's fiscal year-end is December 31. The unadjusted trial balance as of December 31, 2018, appears below.Account TitleDebitsCreditsCash29,000Accounts receivable39,000Supplies1,400Inventory59,000Note receivable19,000Interest receivable0Prepaid rent2,400Prepaid insurance0Office equipment96,000Accumulated depreciation—office equipment36,000Accounts payable30,000Salaries and wages payable0Note payable49,000Interest payable0Deferred revenue0Common stock59,000Retained earnings35,580Sales revenue147,000Interest revenue0Cost of goods sold69,000Salaries and wages expense18,800Rent expense13,200Depreciation expense0Interest expense0Supplies expense1,000Insurance expense5,880Advertising expense2,900Totals356,580356,580Information necessary to prepare the year-end adjusting entries appears below.Depreciation on the office equipment for the year...
Pastina Company sells various types of pasta to grocery chains as private label brands. The company’s...
Pastina Company sells various types of pasta to grocery chains as private label brands. The company’s reporting year-end is December 31. The unadjusted trial balance as of December 31, 2021, appears below.    Account Title Debits Credits Cash 30,000 Accounts receivable 40,000 Supplies 1,500 Inventory 60,000 Notes receivable 20,000 Interest receivable 0 Prepaid rent 2,000 Prepaid insurance 6,000 Office equipment 80,000 Accumulated depreciation 30,000 Accounts payable 31,000 Salaries payable 0 Notes payable 50,000 Interest payable 0 Deferred sales revenue 2,000...
Pastina Company sells various types of pasta to grocery chains as private label brands. The company's...
Pastina Company sells various types of pasta to grocery chains as private label brands. The company's reporting year-end is December 31. The unadjusted trial balance as of December 31, 2021, appears below. Account Title Debits Credits Cash 31,400 Accounts receivable 40,200 Supplies 1,600 Inventory 60,200 Notes receivable 20,200 Interest receivable 0 Prepaid rent 1,000 Prepaid insurance 6,200 Office equipment 80,800 Accumulated depreciation 30,300 Accounts payable 31,200 Salaries payable 0 Notes payable 50,200 Interest payable 0 Deferred sales revenue 2,100 Common...
Pastina Company sells various types of pasta to grocery chains as private label brands. The company’s...
Pastina Company sells various types of pasta to grocery chains as private label brands. The company’s reporting year-end is December 31. The unadjusted trial balance as of December 31, 2021, appears below.    Account Title Debits Credits Cash 30,000 Accounts receivable 40,000 Supplies 1,500 Inventory 60,000 Notes receivable 20,000 Interest receivable 0 Prepaid rent 2,000 Prepaid insurance 6,000 Office equipment 80,000 Accumulated depreciation 30,000 Accounts payable 31,000 Salaries payable 0 Notes payable 50,000 Interest payable 0 Deferred sales revenue 2,000...
Pastina Company sells various types of pasta to grocery chains as private label brands. The company's...
Pastina Company sells various types of pasta to grocery chains as private label brands. The company's reporting year-end is December 31. The unadjusted trial balance as of December 31, 2021, appears below.     Account Title Debits Credits Cash 33,500 Accounts receivable 41,600 Supplies 2,300 Inventory 61,600 Notes receivable 21,600 Interest receivable 0 Prepaid rent 1,700 Prepaid insurance 7,600 Office equipment 86,400 Accumulated depreciation 32,400 Accounts payable 32,600 Salaries payable 0 Notes payable 51,600 Interest payable 0 Deferred sales revenue 2,800...
Pastina Company sells various types of pasta to grocery chains as private label brands. The company's...
Pastina Company sells various types of pasta to grocery chains as private label brands. The company's reporting year-end is December 31. The unadjusted trial balance as of December 31, 2021, appears below.     Account Title Debits Credits Cash 31,700 Accounts receivable 40,400 Supplies 1,700 Inventory 60,400 Notes receivable 20,400 Interest receivable 0 Prepaid rent 1,100 Prepaid insurance 6,400 Office equipment 81,600 Accumulated depreciation 30,600 Accounts payable 31,400 Salaries payable 0 Notes payable 50,400 Interest payable 0 Deferred sales revenue 2,200...
Pastina Company sells various types of pasta to grocery chains as private label brands. The company's...
Pastina Company sells various types of pasta to grocery chains as private label brands. The company's reporting year-end is December 31. The unadjusted trial balance as of December 31, 2021, appears below.     Account Title Debits Credits Cash 31,700 Accounts receivable 40,400 Supplies 1,700 Inventory 60,400 Notes receivable 20,400 Interest receivable 0 Prepaid rent 1,100 Prepaid insurance 6,400 Office equipment 81,600 Accumulated depreciation 30,600 Accounts payable 31,400 Salaries payable 0 Notes payable 50,400 Interest payable 0 Deferred sales revenue 2,200...
Pastina Company sells various types of pasta to grocery chains as private label brands. The company's...
Pastina Company sells various types of pasta to grocery chains as private label brands. The company's reporting year-end is December 31. The unadjusted trial balance as of December 31, 2021, appears below.     Account Title Debits Credits Cash 31,700 Accounts receivable 40,400 Supplies 1,700 Inventory 60,400 Notes receivable 20,400 Interest receivable 0 Prepaid rent 1,100 Prepaid insurance 6,400 Office equipment 81,600 Accumulated depreciation 30,600 Accounts payable 31,400 Salaries payable 0 Notes payable 50,400 Interest payable 0 Deferred sales revenue 2,200...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT