Alpesh Novelli's Nursery has developed the following data in order to calculate the lower of cost or net realizable value for its products. Theindividual products are listed within the categories of trees.SellingPriceCostBroad leaf trees:AshBeech$ 1,9202,380$ 1,8201,720Needle leaf trees:CedarFir$ 2,7403,300$ 1,8703,470Fruit trees:AppleCherry$ 1,9202,480$ 1,5201,920The costs to sell are 10% of selling price.Required:Determine the reported inventory value assuming the lower of cost or net realizable value rule is applied to individual trees.ProductLower ofCostNRVCost or NRVAshBeechCedarFirAppleCherryInventory value$0

An inventory valuation allows a business to assign a monetary value to the inventory. Inventories…

Answered: Novelli's Nursery has developed the…

Novelli's Nursery has developed the following data in order to calculate the lower of cost or net realizable value for its products. The ndividual products are listed within the categories of trees.

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter13: Nonlinear Optimization Models

Section: Chapter Questions

Problem 5P: Jims Camera shop sells two high-end cameras, the Sky Eagle and Horizon. The demand for these two...

See similar textbooks

Similar questions

Stable Paper Delivery has decided to analyze the profitability of five new customers. It buys recycled paper at $12 per case and sells to retail customers at a list price of $14.80 per case. Data pertaining to the five customers are: E (Click the icon to view the data.) Stable Paper Delivery's five activities and their cost drivers are as follows: E (Click the icon to view the activities and cost drivers.) Read the requirements. Requirement 1. Compute the customer-level operating income of each of the five retail Begin by calculating each customer's gross margin. Then calculate the operating incom minus sign for operating losses.) Requirements 1 2 1. Compute the customer-level operating income of each of the five retail customers now being examined (1, 2, 3, 4, and 5). Comment on the results. 2. What insights do managers gain by reporting both the list selling price and the actual selling price for each customer? 3. What factors should managers consider in deciding whether to drop one…
A company has three types of products: gadgets, widgets, and gizmos. The cost and market price of each type is listed below. Complete the table by applying the lower of cost and net realizable value (LCNRV). Do not enter dollar signs or commas in the input boxes. Description Category Cost NRV Individual LCNRV Applied to Category Total Gadget Type 1 Gadgets $1,170 $1,000 $ Gadget Type 2 Gadgets $5,700 $5,600 $ Total Gadgets Widget A Widgets $140 $150 $ Widget B Widgets $130 $190 $ Total Widgets $ tA Gizmo 1 Gizmos $2,280 $2,450 $ Gizmo 2 Gizmos $2,280 $1,630 $ Total Gizmos Total $ A $ EA SA SA EA A
Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. (Hint: One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.) a. Assume that only one product is being sold in each of the four following case situations: (picture1) b. Assume that more than one product is being sold in each of the four following case situations: (picture2)
Cole Company sells both designer and moderately priced fashion accessories. Top management is deciding which product line to emphasize. Accountants have provided the following data: (Click the icon to view the data.) Prepare an analysis to show which product the company should emphasize. (Enter the units displayed per square foot and the contribution marain per square foot to two decimal places.) Units displayed per square foot: Designer Moderately priced Contribution margin per unit Contribution margin per square foot of display space Capacity-Square feet of display space Total contribution margin at capacity Show Transcribed Text Data table CO Average sale price Average variable costs Average contribution margin Average fixed costs (allocated) Average operating income. Designer $ $ Ĉ Product Moderately Priced Per Item Designer Moderately Priced 210 $ 100 110 15 95 $ 85 21 64 5 59 The Cole Company store in Grand Junction, Colorado, has 15,000 square feet of floor space. If Cole…
A tree provider to plant nurseries is trying to use customer lifetime value to determine the value of its customers. Two customers are shown below. Use customer lifetime value to determine the importance of each customer. Use an 8 percent discount rate. Avg. Annual Sales Avg. Profit Margin 10% $12,500 $26,000 20% Do not round intermediate calculations. Round your answers to the nearest dollar. NPV (Customer A): $ NPV (Customer B): $ What do you recommend? Customer B ✓ Customer A: Customer B: is more important. Expected Lifetime 5 years 9 years
Stenback Company sells both designer and moderately priced fashion accessories. Top management is deciding which product line to emphasize. Accountants have provided the following data: 1(Click the icon to view the data.) Prepare an analysis to show which product the company should emphasize. (Enter the units displayed per square foot and the contribution margin per square foot to two decimal places.) Product Designer Moderately Priced Units displayed per square foot: Designer Moderately priced Contribution margin per unit × × Contribution margin per square foot of display space Capacity-Square feet of display space × × Total contribution margin at capacity Decision: (1) 1: Data Table Per Item Designer Moderately Priced Average sale price $220 $88…
The vanilla Latte is one of Starbucks' best- selling coffee drinks. Use the following information to conduct a cost analysis of Starbucks' Vanilla Lattes. Which one of the following equations would be used to calculate the RATE OF RETURN PRICING MODEL using the PRODUCT COST METHOD of Starbucks' Vanilla Lattes? Vanilla Latte product cost Administrative and sales expenses (per Vanilla Latte) Total investment cost (directly related to the manufacturing of Starbucks Vanilla Lattes) Total lattes produced Ideal profit percentage a. 15+ ((0.35 x 120 000)/8100) O b. (R15/(1-35%)) c. (R15+ (35% of R20)) d. 20+ ((0.35 x 120 000)/8100) R15 R5 R120 000 8100 35%
A tree provider to plant nurseries is trying to use customer lifetime value to determine the value of its customers. Two customers are shown below. Use customer lifetime value to determine the importance of each customer. Use a 7 percent discount rate. Avg. Annual Sales Avg. Profit Margin Customer A: Customer B: $26,500 $14,000 Do not round intermediate calculans. Round your answers to the nearest dollar. NPV (Customer A): $ 25% 15% Expected Lifetime 11 years 7 years NPV (Customer B): $ What do you recommend? -Select- is more important.
A company is providing its product to the consumer through the wholesalers. The managing director of the company thinks that if the company starts selling through retailers or to the consumers directly, it can increase its sales, charge higher prices and make more profit. On the basis of the following information and consider variable cost is rial 2.50 per unit and fixed cost is rial 50000. (a) Advise the managing director whether the company should change its channel of distribution or not (with calculation and Justification). (b) Provide suggestions and recommendations on the basis of analysis.
The Camera Shop sells two popular models of digital SLR cameras (Camera A Price: 230, Camera B Price: 310). The sales of these products are not independent of each other, but rather if the price of one increase, the sales of the other will increase. In economics, these two camera models are called substitutable products. The store wishes to establish a pricing policy to maximize revenue from these products. A study of price and sales data shows the following relationships between the quantity sold (N) and prices (P) of each model: NA = 192 - 0.5PA + 0.25PB NB = 305 + 0.08PA - 0.6PB Construct a model for the total revenue and implement it on a spreadsheet. Develop a two-way data table to estimate the optimal prices for each product in order to maximize the total revenue. Vary each price from $250 to $500 in increments of $10. Max profit occurs at Camera A price of $ . Max profit occurs at Camera B price of $ .
Q1. Murray furniture store sells couches as a retailer. The wholesale cost to them of their most popular model of couch varies depending on how many they purchase for sale. For the first 200 couches the cost is $299 each; for the next 200 couches it drops to $250 each; and for every couch after that it costs $225. Create an excel function using the IF function to show the gross profit under the following scenarios: a. b. It sells at a price of $650 and 350 units are purchased for sale and sold It sells at a price of $625 and 300 units are purchased for sale and sold It sells at a price are $700 and 1,000 units are purchased for sale and sold C.
Missing Data: Basic CVP Concepts Fill in the missing amounts in each of the eight case situations below. Each case is independent of the others. (Hint: One way to find the missing amounts would be to prepare a contribution format income statement for each case, enter the known data, and then compute the missing items.) a. Assume that only one product is being sold in each of the four following case situations: b. Assume that more than one product is being sold in each of the four following case situations: