Business, 08.02.2021 18:50 Leftie500

LNQ Inc. is an environmentally friendly company which sells packed organic vegetables in biodegradable bags. Currentlythe monthly fixed cost associated with its operation is estimated at $65,000. The variable cost of a bag is $1.35 and it iscurrently sold for $2.00. Presently, the maximum operating capacity is 120,000 bags per month. 1. Based on the situation described above, develop a spreadsheet model that calculates the monthly profit as a function of the number of bags produced and sold:
• Be sure to put all numerical values in separate cells from formulas.
• Format all dollar amounts with $ signs and 0 decimals for all values, except for the variable cost and the selling price (2 decimals). Format all other numerical amounts as Number with thousands separators.
• Name this sheet LNQSpring21 Model.
2. Write a formula to calculate the monthly breakeven number of vegetables bags on your spreadsheet. Show the mathematical procedure to get to the formula in your written report (use the notation presented in class). Format this cell as a number with a comma and 0 decimals. In a separate cell compute the breakeven number of bags as a percentage of the maximum monthly capacity. Format this cell as a percentage with 0 decimals.
3. The company is considering increasing the selling price per bag. Build a one-way data table based on your spreadsheet model using Excel's Data Table command to show the monthly breakeven number of vegetable bags and percentage of maximum capacity with the price ranging from $1.50 to $3.00 per bag (in increments of $0.15).
• Put a border around the contents of the table.
• Format the amount inside the table as a Number with 0 decimals.
• Format percent values inside the table as Percentage with 0 decimals.
4. The company is considering changing its production process to add an extra cover to the bag to reduce refrigeration times that would increase the cost of a bag. Management wants to estimate how profit reacts to changes in both the variable cost and the selling price. Construct a two-way data table based on your spreadsheet model using Excel's Data Table command to show the profit associated with the selling price ranging from $1.50 to $2.75 in increments of $0.25) as the variable cost per bag varies from $0.80 to $1.50 (in increments of $0.10 across the top of the table and assuming LQN produces at maximum capacity).
• Put a border around the contents of the table.
• Format all dollar amounts as Currency with 0 decimals.
• Apply conditional formatting to the cells in the table that exceed $25,000.

Answers: 1

Show answers

Another question on Business

Business, 22.06.2019 06:40

Self-interest achieve society’s economic goals because producers know which goods consumers want the most. as consumers and producers exercise their freedom to act in their own self-interest, markets will produce the desired goods at the lowest possible cost. consumers and producers both operate based on society’s economic goals. consumers know which goods can be produced at the lowest cost. there is a wide variety of desired goods and services in a market system because producers determine what to produce. consumers change their minds frequently. there is always a need to produce something new and improved. individual wants are diverse. what is produced is ultimately determined by consumers, because if the goods offered are not what consumers want, consumers will not buy them. producers, because they are driven by profits. producers, because they determine what to produce. consumers, because they participate in marketing surveys.

Answers: 2

Answer

Business, 22.06.2019 09:00

Asap describe three different expenses associated with restaurants. choose one of these expenses, and discuss how a manager could handle this expense.

Answers: 1

Answer

Business, 22.06.2019 13:00

Reliability and validity reliability and validity are two important considerations that must be made with any type of data collection. reliability refers to the ability to consistently produce a given result. in the context of psychological research, this would mean that any instruments or tools used to collect data do so in consistent, reproducible ways. unfortunately, being consistent in measurement does not necessarily mean that you have measured something correctly. to illustrate this concept, consider a kitchen scale that would be used to measure the weight of cereal that you eat in the morning. if the scale is not properly calibrated, it may consistently under- or overestimate the amount of cereal that’s being measured. while the scale is highly reliable in producing consistent results (e.g., the same amount of cereal poured onto the scale produces the same reading each time), those results are incorrect. this is where validity comes into play. validity refers to the extent to which a given instrument or tool accurately measures what it’s supposed to measure. while any valid measure is by necessity reliable, the reverse is not necessarily true. researchers strive to use instruments that are both highly reliable and valid.

Answers: 1

Answer

Business, 22.06.2019 17:10

To : of $25 up to 35 2 35 up to 45 5 45 up to 55 7 55 up to 65 20 65 up to 75 16 is$25 up to $35 ?

Answers: 1

Answer

You know the right answer?

LNQ Inc. is an environmentally friendly company which sells packed organic vegetables in biodegradab...

Questions

Business, 24.08.2021 01:10

Which of the following are true about possible scams a. they are allowed the same rights in advertising as legitimate offers b. they are...