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, 21.06.2019 21:00

Chipotle mexican grill, the american mexican food chain restaurant, opened its first restaurant in the united states in 1993. in 2010, chipotle opened its first restaurant in the united kingdom in london on charing cross. by late may 2013, the company had 6 restaurants in london, but they have not been doing well even though the british have taken a liking to mexican food (boyle, 2013). why has this successful u.s. chain not seen the same success overseas? if you were chipotle's ceo, how would you fix this situation? what is an alternative means of venturing outside of its domestic markets that may allow for a competitive advantage? then, pick a company that has not yet expanded overseas, or if it has expanded, suggest a different strategy for entrance into an overseas market that you feel would be more strategic for the company. research its rivals in the global marketplace and market conditions in the overseas market you are targeting. justify your recommended entry strategy based on these industry and market conditions.

Answers: 1

Answer

Business, 21.06.2019 22:50

Synovec co. is growing quickly. dividends are expected to grow at a rate of 24 percent for the next three years, with the growth rate falling off to a constant 7 percent thereafter. if the required return is 11 percent, and the company just paid a dividend of $2.05, what is the current share price? (do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

Answers: 2

Answer

Business, 22.06.2019 06:00

For 2018, rahal's auto parts estimates bad debt expense at 1% of credit sales. the company reported accounts receivable and an allowance for uncollectible accounts of $86,500 and $2,100, respectively, at december 31, 2017. during 2018, rahal's credit sales and collections were $404,000 and $408,000, respectively, and $2,340 in accounts receivable were written off.rahal's accounts receivable at december 31, 2018, are:

Answers: 2

Answer

Business, 22.06.2019 10:00

Marco works in the marketing department of a luxury fashion brand. he is making a presentation on the success of a recent marketing campaign that included a fashion show. which slide elements can he use to include photographs and footage of the fashion show in his presentation? marco can use the: table images audio option to include photographs and the: flowcharts images video option to include footage of the fashion show.

Answers: 1

Answer

You know the right answer?

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

Questions