Problem 1 The table in worksheet Problem 1 is a list of orders from a company that sells sports products Each row is an order Only one type of product is sold in each order, but the quantity and price of each unit vary across orders Information about each order includes location, customer, segment, product sold, order date, the list price per unit, the price each unit was actually sold in the order (unit price), quantity of units sold, revenue (sales), and percent discount on each other The company charges customers to ship the orders and uses a shipping rate for each order that depends on the region and business segment Shipping is 6 of revenue for orders shipped to the North America Region in the Business Segment of Bikes The shipping rate is 2 for all other orders Show the appropriate rate for each order in column ShipRate The company pays sales tax on revenue of each order Tax is 9 of revenue if revenue is less than $1,000, 8 if revenue is greater than or equal to $1,000 but less than $2,000, and 7 if revenue is greater than or equal to $2,000 Add a column TaxRate with the tax rate On column GrossSale calculate the revenue of each order plus shipping (in dollars) minus tax (in dollars) Market Customer Business Segment Category Model Color SalesDate ListPrice UnitPrice OrderQty Discount Revenue ShipRate TaxRate GrossSale Central Great Bicycle Supply Bikes Mountain Bikes Mountain 100 Black 05 16 09 $3,375 $3,289 6 3 $19,736 Northwest Metro Cycle Shop Components Brakes Front Brakes Silver 09 01 09 $107 $64 4 40 $256 Southwest Sturdy Toys Bikes Mountain Bikes Mountain 200 Black 08 12 09 $2,295 $2,292 4 0 $9,168 Northwest Metro Cycle Shop Bikes Mountain Bikes Mountain 200 Silver 07 10 10 $2,320 $1,392 4 40 $5,568 Canada Quick Parts and Service Bikes Touring Bikes Touring 1000 Blue 03 29 10 $2,384 $1,430 1 40 $1,430

The Answer is in the image, click to view ...

Question: Problem 1 The table in worksheet Problem 1 is a list of orders from a company that sells sports products. Each row is an order.

Problem 1

The table in worksheet "Problem 1" is a list of orders from a company that sells sports products. Each row is an order. Only one type of product is sold in each order, but the quantity and price of each unit vary across orders. Information about each order includes location, customer, segment, product sold, order date, the list price per unit, the price each unit was actually sold in the order (unit price), quantity of units sold, revenue (sales), and percent discount on each other.

The company charges customers to ship the orders and uses a shipping rate for each order that depends on the region and business segment. Shipping is 6% of revenue for orders shipped to the North America Region in the Business Segment of Bikes. The shipping rate is 2% for all other orders. Show the appropriate rate for each order in column ShipRate.
The company pays sales tax on revenue of each order. Tax is 9% of revenue if revenue is less than $1,000, 8% if revenue is greater than or equal to $1,000 but less than $2,000, and 7% if revenue is greater than or equal to $2,000. Add a column TaxRate with the tax rate.
On column GrossSale calculate the revenue of each order plus shipping (in dollars) minus tax (in dollars).

Market

Customer

Business Segment

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Question 3- develope a spreadsheet analysis which can be used to assess the profitability of the three customer groups of Blue Ridge (large, medium and small customer account sizes) Use tables 1-4...

Case 5-1 (Static) Blue Ridge Manufacturing Background: Blue Ridge Manufacturing is one of a dozen companies that produces and sells towels for the U.S. "sports towel" market. A "sports towel" is a...

What would you consider most important in analyzing the data (product or customer) and why? Given your answer in #4 above which segment should be given more resources (i.e. expanded)? Which segment...

Read the given data and tables and then answer the given two questions ASAP. Tables: (Table 4 is divided into 2 screenshots) Questions: Seven Flags Manufacturing BACKGROUND: Seven Flags Manufacturing...

Please see the files attached... for the managerial accounting Table 1 Blue Ridge Manufacturing Company. Sales information - current year. Sale in units, by customer category Large (n=8) Medium...

What type of cost system does Blue Ridge use, and is it consistent with strategy? Develop a spreadsheet analysis which can be used to assess the profitability of the three customer groups of Blue...

Background: Blue Ridge Manufacturing is one of a dozen companies that produces and sells towels for the U.S. "sports towel" market. A "sports towel" is a towel that has the promotion of an event or a...

Blue Ridge Manufacturing Background: Blue Ridge Manufacturing is one of a dozen companies that produces and sells towels for the U.S. "sports towel" market. A "sports towel" is a towel that has the...

Need stakeholder analysis, swot analysis and pestle analysis for the below case study- Bella Beverages Inc. 1 Bella Beverages Inc. Overview Bella Beverages Inc. (BB) is a Canadian company traded on...

create an SBU analysis based on nikes 2004 annual report. where would you increase investments maintain current investments, divest current investments(or get rid of lines) Andrew Amphlett sat back...

(a) If the probability density of X is given by Find E(X), E(X 2 ), and E(X 3 ). (b) Use the results of part (a) to determine E( X 3 + 2X 2 - 3X + 1). elsewhere

Describe how each of the following characteristics of organizations applies to corporations. 1. Duration of life 2. Owner liability 3. Legal status 4. Tax status of income 5. Owner authority and...

16. Suppose Fiat recently entered into an Agreement and Plan of Merger with Case for $4.3 billion. Prior to the merger, the market for four-wheel-drive tractors consisted of five firms. The market...

P-1) (100 Pts.) A chemical manufacturing company (CMC) has a contract for the procurement of the neccssaly chemicals from four suppliers. The chemicals purchased from Supplier A are priced at $20...

3 Does it really matter? Remember, this survey is for material to be used in marketing. Do you think students will infer that quotes from very successful graduates mean that every student at the...

Now imagine that you are presenting the topic to a receptive audience, a neutral audience, and a hostile audience. What do you as a speaker need to do in order to prepare to present your topic to...

What do you think about children playing competitive sports? (general)