Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3.9. Enter the following inventory turnover ratio for Pike's Peak Mountain Bike for 20x9 from WP A.4 rounded to 2 decimal places (note that this

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
3.9. Enter the following inventory turnover ratio for Pike's Peak Mountain Bike for 20x9 from WP A.4 rounded to 2 decimal places (note that this is a "times" ratio, not a percentage) 3.10. Enter the following inventory turnover ratio for Raw Materials for 20x9 from WP A.4 rounded to 2 decimal places (note that this is a "times" ratio, not a percentage) 3.11. Enter the following inventory turnover ratio for Other Purchased Parts for 20x9 from WP A.4 rounded to 2 decimal places (note that this is a "times" ratio, not a percentage) A1 XV Jx WPA.4 BRONY'S BIKES Prepared by! BRONY'S BIKES INVENTORIES December 31, 2019 and 2018 Date: Reviewed by: Units of 12/31/20x9 Cost per Unit Turnover Total $51 Finished Goods Grand Prix Touring Bike Phoenix Touring bike Pikes Peak Mountain Bike Himalaya Mountain Bike Waistliner stationary Bike 166 $2,162,298 $1,831,896 $7,778,498 $1,073,633 $2,669,766 1121 $209 Total Finished Goods Inventory 915,516,091 $14 Materials and Purchased Parts Raw Materials taventory Derailleurs taventory Tires Inventory Handlebar Investory 22 Other Purchased Parts $18 442858 305556 997642 512387 2336780 $6,200,012 $5,500,008 $3,990,568 $6,099,096 $7,010,340 1277604 8552751 Total Materials and Purchased Parts $26,800,024 Units of Units Taventory 12/31/20x8 Inventory Purchased cost per Unit Finished Goods Grand Prix Touring Bike 20.85 Phoenix Touring Bike 16882 25.06 Pikes Peak Mountain Bike 54548 16.10 Himalaya Mountain Bike 3877 40.87 WP ALWPA2WPA3WP A4 WP AS WP A6WP AY + $1,384, 185 $1,198,622 $5,309,348 $535,026 Units Inventory 12/31/2018 Cost per Unit Inventory Total 25167 16882 20.85 33 Finished Goods 34 Grand Prix Touring Bike 35 Phoenix Touring Bike 36 Pikes Peak Mountain Bike 37 Himalaya Mountain Bike 38 Waistliner Stationary Bike $1,384, 185 $1,198,622 $5,509,348 $535,026 $1,514,832 3877 6644 30.45 $228 40 Total Finished Goods Inventory $10,142,013 6.96 42 Materials and Purchased Parts: 43 Raw Materials inventory 44 Derailleurs Inventory 45 Tires Inventory 46 Handlebar Inventory 47 Other Purchased Parts 276899 213630 447985 286476 1778326 3211659 1232660 7889650 $3,599,687 $3,418,080 $1,791,940 $2,005, 332 $5,334,978 4.44 Total Materials and Purchased Parts $16,150,017 * Inventory turnover denominator in units from units for each product line 2019 Pro WP A.2 Sales Revenue 2012 Total Percent Phoenix Touring Pikes Peak 20 Percent 56 Units Selling Price per Unit 498524 100.000 100.000 984386 $135 100.001 59 Total Sales Revenue $335,000,036 $50,659,050 $47, 359, 780 $232,892,110 61 2018 From WP 1.1 Sales Revenue Total Tong Percent Phoenix TOUC Pikes Peak Mountain Percent 524759 64 Units 65 Selling Price per Unit WP A1 WPA2 100.003 423112 $92 100.000 $131 100.00L WPA3 WP 4.4 WP A.5 WP A6 WP A7 + Balling Price per it 2018 Free MP A.1 Sales Selling Price per mit 3.9. Enter the following inventory turnover ratio for Pike's Peak Mountain Bike for 20x9 from WP A.4 rounded to 2 decimal places (note that this is a "times" ratio, not a percentage) 3.10. Enter the following invertory turnover ratio for Raw Materials for 20x9 from WP A.4 rounded to 2 decimal places (note that this is a "times" ratio, not a percentage) 3.11. Enter the following inventory turnover ratio for Other Purchased Parts for 20x9 from WP A.4 rounded to 2 decimal places (note that this is a "times" ratio, not a percentage) BRONY'S BIKES INVENTORIES December 31, 2019 and 20x8 2019 Prepared by: Date: Reviewed by Date: Units of Inventory Tavestory rnover 12/31/2019 cost per Unit T otal & Finished Goods Grand Prix Touring Bike 10 Phoenix Touring Bike Pike's Peak Mountain Bike 12 Himalaya Mountain Bike 13 Waistliner Stationary Bike 4239 27756 85478 $51 $66 $91 $121 $209 $2,162,298 $1,831,896 $7.778.498 $1,073,633 $2,669,766 Total Finished Goods Inventory $15,516,091 442858 2133111 $18 17 Materials and Purchased Parts 10 Raw Materiale Inventory 19 Derailleurs Taventory Tires Inventory 21 Sandlebar Inventory 22 Other Purchased Parts 6487 305556 997642 512387 2316780 4665149 1277604 $6,200,012 $5,500,000 33,990,568 54,099, 016 $7,010,340 Total Materials and Purchased Parts $26,800,024 Units of Teventory Turnover Purchased Cost per Unit Total S55 33 Finished Goods Grand Prix Touring Bike Phoenix Touring Bike 36 Pikes Peak Mountain Bike Himalaya Mountain Bike 25167 16882 56548 871 84.185 $1,198,622 $5,509,48 $535,026 $101 3827 8138 Units of Inventory Units Purchased Inventory Turnover" 12/31/20x8 Cost per Unit Total 33 Finished Goods 34 Grand Prix Touring Bike 35 Phoenix Touring Bike 36 Pike's Peak Mountain Bike 37 Himalaya Mountain Bike 38 Waistliner Stationary Bike 25167 16882 54548 3077 6644 BBB 20.85 25.06 16.10 40.87 30.45 855 972 $101 $138 $228 $1,384, 185 $1,198,622 $5,509,348 $535,026 $1,514,832 40 Total Finished Goods Inventory $10,142,013 $13 42 Materials and Purchased Parts: 43 Raw Materials Inventory 44 Derailleurs Inventory 45 Tires Inventory 46 Handlebar Inventory 47 Other Purchased Parts $16 213630 447985 286476 1778326 1927688 999741 3211659 1232660 7889650 6.96 4.68 7.17 4.30 4.44 $3,599,687 $3,418,080 $1,791,940 $2,005, 332 $5,334,978 $3 Total Materials and Purchased Parts $16, 150,017 Inventory turnover denominator in units from units for each product line 52 2029 Prom WP A.2 Sales Revenue o Tron WT 4.2 Sales Revenge Total Grand Pris Touring 498524 8335,000,034 0,699,050 8 Pro WP A.1 sales Revenue elling Price per uit otal sales Revesse $280,000, 104 3 2.782,648

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Security And Auditing Protecting Data Integrity And Accessibility

Authors: Hassan A. Afyouni

1st Edition

0619215593, 9780619215590

More Books

Students also viewed these Accounting questions

Question

Does mind reading help or hinder communication?

Answered: 1 week ago