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 03:00

Insurance companies have internal controls in place to protect assets, monitor the accuracy of accounting records and encourage operational efficiencies and adherence to policies. these internal controls are generally of two types: administrative controls and accounting controls. administrative controls are the policies and procedures that guide the daily actions of employees. accounting controls are the policies and procedures that delineate authorizations of financial transactions that are done, safeguard assets, and provide reports on the companyâ€™s financial status in a reliable and timely manner. internal controls should include both preventative and detective controls. the purpose of preventative controls is to stop problems and errors before they occur. detective controls identify problems after they have occurred. preventative controls are usually more effective at reducing problems, but they also tend to be more expensive. internal controls must be flexible to adjust for changes in laws and regulations in addition to adding new products or modifying current ones. companies must also do regular analyses to ensure that the benefits of implementing the controls are worth their costs. when concerned about paying unwarranted insurance claims which type of control would be useful?

Answers: 2

Answer

Business, 22.06.2019 09:40

Catherine de bourgh has one child, anne, who is 18 years old at the end of the year. anne lived at home for seven months during the year before leaving home to attend state university for the rest of the year. during the year, anne earned $6,000 while working part time. catherine provided 80 percent of anne's support and anne provided the rest. which of the following statements regarding whether anne is catherine's qualifying child for the current year is correct? a.anne is a qualifying child of catherine.b.anne is not a qualifying child of catherine because she fails the gross income test.c.anne is not a qualifying child of catherine because she fails the residence test.d.anne is not a qualifying child of catherine because she fails the support test.

Answers: 2

Answer

Business, 22.06.2019 17:40

To appeal to a new target market, the maker of hill's coffee has changed the product's package design, reformulated the coffee, begun advertising price discounts in women's magazines, and started distributing the product through gourmet coffee shops. what has been changed? a. the product's perceptual value. b.the product's 4ps. c. the method used in its target marketing. d. the ownership of the product line. e. the product's utility.

Answers: 3

Answer

Business, 23.06.2019 16:30

Which are the best examples of costs that should be considered when creating a project budget? over budget and under budget production costs and capacity cost of living and allocated costs total budget and allocated costs

Answers: 2

Answer

You know the right answer?

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

Questions