I've prepared two sheets in a workbook - one for the master data, i.e the unit price of each product and the discount percentages, a second one to calculate the price quote.
The master data looks like this:
The formulas in the second worksheet are as follows:
It gives the following results in 3 different scenarios:
I've also uploaded the spreadsheet here for you:
https://drive.google.com/file/d/146o6egJGkgGlr2wDV8WLgedUg24dot4r/view?usp=sharing
Hope this helps :)
excel for accounting Buckeye Company sells three products and offers quantity discounts to the customers. Buckeye...
Suppose that a company offers quantity discounts. If up to 1000 units are purchased, the unit price is $10; if more than 1000 and up to 5000 units are purchased, the unit price is $9; and if more than 5000 units are purchased, the unit price is $7.50. Develop a spreadsheet using the VLOOKUP function to find the unit price associated with any or-der quantity and compute the total cost of the order. S&S No. 106 INVOICE Customer G. Kite...
Texas-Q Company produces and sells barbeque grills. Texas-Q sells three models: a small portable gas grill, a larger stationary gas grill, and the specialty smoker. In the coming year, Texas-Q expects to sell 15,900 portable grills, 47,700 stationary grills, and 5,300 smokers. Information on the three models is as follows: Portable Stationary Smokers Price $92 $199 $246 Variable cost per unit 50 127 136 Total fixed cost is $1.918,280 Required: 1. What is the sales mix of portable grills to...
Texas-Q Company produces and sells barbeque grills. Texas-Q sells three models: a small portable gas grill, a larger stationary gas grill, and the specialty smoker. In the coming year, Texas-Q expects to sell 19,600 portable grills, 44,100 stationary grills, and 4,900 smokers. Information on the three models is as follows: Stationary Portable $86 Smokers $245 Price $198 Variable cost per unit - 43 126 144 Total fixed cost is $2,026,200. Required: 1. What is the sales mix of portable grills...
Texas-Q Company produces and sells barbeque grills. Texas-Q sells three models: a small portable gas grill, a larger stationary gas grill, and the specialty smoker. In the coming year, Texas-Q expects to sell 14,100 portable grills, 47,000 stationary grills, and 4,700 smokers. Information on the three models is as follows: Portable Stationary Smokers Price $86 $195 $245 Variable cost per unit 42 126 144 Total fixed cost is $1,947,530. Required: 1. What is the sales mix of portable grills to...
Instructions Texas-Q Company produces and sells barbeque grills. Texas-Q sells three models: a small portable gasgrill, a larger stationary gas grill, and the specialty smoker. In the coming year, Texas-Q expects to sell 16,200 portable grills, 48,600 stationary grills, and 5,400 smokers. Information on the three models is as follows: Portable $93 Stationary $203 Smokers $250 Price Variable cost per unit 49 131 141 Total fixed cost is $1,911,350. Required: 1. What is the sales mix of portable grills to...
LP Large Problem (4 marks for question, 6 marks for worksheet) A company sells three products: A, B, and C. The company has customer orders for 2,000 units of A, 3.750 B's, and 1,700 C's. The company makes the products in-house, which requires production and shipping resources (constraints 1, 2) as shown in the table below. The company can outsource some demand for A and B, but cannot outsource C. Outsourcing requires no production or shipping resources. The company wants...
An online company sells hundreds of office supply products on its e-Commerce store. It has asked you to design and implement a sales order processing system which will be used by users in our Operations department to process sales orders. Here is an overview of the sales order process. Customers make purchases by placing orders. Each customer has a customer number and profile (such as name, shipping address). To simplify the matter, each time an order is placed, only one...
Supply Club, Inc., sells a variety of paper products, office supplies, and other products used by businesses and individual consumers. During July 2018 it started a loyalty program through which qualifying customers can accumulate points and redeem those points for discounts on future purchases. Redemption of a loyalty point reduces the price of one dollar of future purchases by 20% (equal to 20 cents). Customers do not earn additional loyalty points for purchases on which loyalty points are redeemed. Based...
1) X Company incurred the following costs in 2017: Factory insurance $5,629 Customer service 4,766 Advertising costs 4,594 Factory maintenance 5,023 Direct labor 5,972 Direct materials 4,514 Sales salaries 5,023 Factory utilities 5,153 Research & Development 5,599 Material handling 4,174 What was total overhead in 2017? 2) X Company had the following inventory account balances in 2017: Account January 1 December 31 Materials $14,524 $16,900 Work in Process 14,622 21,768 Finished Goods 14,594 14,594 The following additional information for the...