BUSL.WK8 DISCUSSION

Please provide step by step solution with answers and provide an excel solution.

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 $ .

Bigdog Company distributes pet products. Its ABC system has five activities:   Activity Area Cost Driver Rate in 2020 1. Order processing $50 per order 2. Line-item ordering $5 per line item 3. Store deliveries $40 per store delivery 4. Carton deliveries $6 per carton 5. Shelf-stocking $19 per stocking hour   Rufus McBrain, the controller of Bigdog Company, wants to use this ABC system to examine customer profitability. He focuses on two of his customers to find out the insights he can gain from using this system. Data for these two customers in April 2020 are as follows:     Pet Store Annerley RSPCA store Springwood Total orders 13 7 Average line items per order 11 19 Total store deliveries 5 7 Average cartons shipped per store delivery 21 18 Average hours of shelf stocking per store delivery 0.5 0.75 Average revenue per delivery $2,600 $1,900 Average cost of goods sold per delivery…

Bigdog Company distributes pet products. Its ABC system has five activities:   Activity Area Cost Driver Rate in 2020 1. Order processing $50 per order 2. Line-item ordering $5 per line item 3. Store deliveries $40 per store delivery 4. Carton deliveries $6 per carton 5. Shelf-stocking $19 per stocking hour   Rufus McBrain, the controller of Bigdog Company, wants to use this ABC system to examine customer profitability. He focuses on two of his customers to find out the insights he can gain from using this system. Data for these two customers in April 2020 are as follows:     Pet Store Annerley RSPCA store Springwood Total orders 13 7 Average line items per order 11 19 Total store deliveries 5 7 Average cartons shipped per store delivery 21 18 Average hours of shelf stocking per store delivery 0.5 0.75 Average revenue per delivery $2,600 $1,900 Average cost of goods sold per delivery…

Stylish Sitting is a retailer of office chairs located in San Francisco, California. Due to increased market competition, the CFO of Stylish Sitting has grown worried about the firm's upcoming income stream. The CFO asked you to use the company financial information provided below.           Sales price $ 73.00   Per-unit variable costs:       Invoice cost   40.45   Sales commissions   17.45   Total per-unit variable costs $ 57.90   Total annual fixed costs:       Advertising $ 54,500   Rent   77,000   Salaries   225,000   Total annual fixed costs $ 356,500       If 38,900 office chairs were sold, Stylish Sitting's operating income (πB) would be: (Do not round intermediate calculations.)   Multiple Choice   $230,890.   $270,890.   $200,890.   $330,890.

Alyssa Stuart is thinking of starting a store that specializes in handmade Viennese style bentwood chairs. Before opening her store, Alyssa is curious about how her profit, revenue, and variable costs will change depending on the amount she charges for the chairs. Alyssa would like you to perform the work required for this analysis and has given you the data. Here are a few things to consider while you perform your analysis: Current competitive prices for Viennese style bentwood chairs are between $225 and $275 a chair. Variable costs will be either $100 or $150 a chair depending on the types of material Alyssa chooses to use. Fixed costs are $10,000 a month. Create an Excel file containing the following information: Alyssa's chairs - Price One Alyssa's chairs - Price Two     Chair Price  $          225 Chair Price  $      275   Variable Cost per chair  $          125 Variable Cost per chair  $      150   Fixed Cost  $     10,000 Fixed Cost  $…

First image is with the answers that are given and the questions scenarios . Second image is with more question scenarios . I need help and explanations on what answer to match with what scenarios .It’s about the best way for funding business in the given scenario

Customer profitability, distribution. Best Drugs is a distributor of pharmaceutical products. Its ABC system has five activities:

LO18.1: Understand how most wholesalers and retailers set their prices by using markups. LO18.2: Understand the advantages and disadvantages of average-cost pricing. LO18.3: Know how to use break-even analysis to evaluate possible prices. LO18.5: Understand other demand-oriented factors that influence price setting. Eleven-year-old Mallory is a budding entrepreneur. She is always coming up with new business ideas. In early summer 2018, her latest venture is a lemonade stand. Mallory is focused on making a high level of profits – she was saving for a new bike. Mallory is trying to develop a marketing strategy to help her achieve her goals. Last year Mallory helped a friend with a lemonade stand. This year she wants to run her own business. Her parents expect her to pay for almost everything related to her business. Her dad built her a small lemonade stand – and while he donated his time, he did ask for the $12 in materials needed to build the stand. Mallory had to purchase other…

ABC, wholesale, customer protability. Veritek Wholesalers operates at capacity and sells furniture items to four department-store chains (customers). Mr. Veritek commented, “We apply ABC to determine product-line protability. The same ideas apply to customer protability, and we should nd out our customer protability as well.” Veritek Wholesalers sends catalogs to corporate purchasing departments on a monthly basis. The customers are entitled to return unsold merchandise within a six-month period from the purchase date and receive a full purchase price refund. The following data were collected from last year’s operations:

Customer protability, distribution. Best Drugs is a distributor of pharmaceutical products. Its ABC system has five activities:

Fan Base (FB) operates a megastore featuring sports merchandise. It uses an E0Q decision model to make inventory decisions. It is now considering inventory decisions for its Los Angeles Galaxy soccer jerseys product line. This is a highly popular item. Data for 2011 are as follows: Expected annual demand for Galaxy jerseys Ordering cost per purchase order Carrying cost per year Each jersey costs FB $40 and sells for $80. The $7 carrying cost per jersey per year comprises the required return on investment of $4.80 (12% x $40 purchase price) plus $2.20 in relevant insurance, handling, and theft-related costs. The purchasing lead time is 7 days. FB is open 365 days a year. a) Calculate the E0Q. Required 10,000 $200 $7 per jersey b) Calculate the number of orders that will be placed each year. c) Calculate the reorder point.

Breok-Even and Target Profit Analysis The Shirt Works sells a large variety of tee shirts and sweatshirts. Steve Hooper, the owner, is thinking of expanding his sales by hiring high school students, on a commission basis, to sell sweatshirts bearing the name and mascot of the local high school. These sweatshirts would have to be ordered from the manufacturer six weeks in advance, and they could not be returned because of the unique printing required. The sweatshirts would cost Hooper $8 each with a minimum order of 75 sweatshirts. Any additional sweatshirts would have to be ordered in increments of 75. Since Hooper’s plan would not require any additional facilities, the only costs associated with the project would be the costs of the sweatshirts and the costs of the sales commissions. The selling price of the sweatshirts would be $13.50 each. Hooper would pay the students a commission of $1.50 for each shirt sold. Required: 1. What level of unit sales and dollar sales is needed to…

i need the solution for the two blanks in requirement 3. the safety stock ____ pairs & the reorder point _____ pairs of shoes. Check the image for requirement 3 as i alreacy have most blanks filled out

Chugg promotes the idea that the company can help students prepare for academic success in college. Chugg operates two divisions: (1) major publishers, and (2) niche publishers for specialized courses. The company is considering the possibility of adding a "custom" product line that accumulates material from rogue professors who use their own material or test banks. The company's current segment income statement follows: Major Niche Total Sales $ 12,000,000 $ 4,000,000 $ 16,000,000 Variable expenses 2,400,000 1,000,000 3,400,000 Contribution margin 9,600,000 3,000,000 12,600,000 Fixed expenses: Traceable AND Controllable 4,100,000 2,400,000 6,500,000 Traceable NOT Controllable 3,000,000 1,800,000 4,800,000 Segment margin 2,500,000 (1,200,000) 1,300,000 Fixed expenses: Common 1,000,000 Net income $ 300,000 The company expects the Custom Division to generate an additional contribution margin of $1,400,000. Custom Division will hire new content managers for $1,000,000. The new product…