Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ride-Out sales are highest in the spring and summer months, when private consumer purchases peak. The most profitable months are always March to May, when

Ride-Out sales are highest in the spring and summer months, when private consumer purchases peak. The most profitable months are always March to May, when outdoor adventure stores are preparing for the summer season.

This past summer was a difficult one. Due to poor weather across the region, annual sales last year dipped 4% over the prior three-year average. Fortunately, there is no indication that the bad weather will repeat this year.

Month Units sold

January 74

February 90

March 210

April 240

May 255

June 205

July 180

August 160

September 90

October (forecast) 85

November (forecast) 70

December (forecast) 65

Power-Ride had a one-time special order in April for 15 Ride-Outs that is not expected to occur this upcoming year. One of Power-Ride's retailers, Outfitters Inc., recently closed. It accounted for 5% of regular sales for January to March, and 8% of regular sales for the remainder of the year. The Ride-Outs currently sell for $1,400 per unit, and the company is planning to increase the selling price by 5% for the coming year.

Market research shows that two-wheeled personal transportation vehicles are gaining popularity with those who live in hilly or windy areas and those with reduced fitness levels. As a result, experts are predicting that sales growth in this market will be at least 6% in the coming year. Power-Ride requires inventories of finished goods on hand at the end of each month to be equal to 50% of the following month's budgeted sales. Power-Ride expects to have 20 units on hand on December 31, 2019.

image text in transcribed
You have completed the budgets for the production inputs for 2020, summarized below. January February March April May June Direct materials $30,624 $50,945 $75,547 $76,000 $63,230 $50,584 Direct labour $30,019 $49,940 $74,055 $74,499 $61,981 $49,585 Manufacturing overhead $12,615 $20,986 $31, 120 $31,307 $26,046 $20.837 July August September October November | December Direct materials $41,678 $32,772 $29,923 $27,608 $23,867 $22,528 Direct labour $40,855 $32,126 $29,332 $27,062 $23,395 $22,083 Manufacturing overhead $17,169 $13,500 $12,326 $11,372 $ 9,832 $ 9,280 The cost per unit of the open inventory in January is expected to be $705 per unit. You were also provided with the following to use for the selling and administrative budget. Prior-year monthly expense information and assumptions: Shipping costs $45 per unit (no expected change) Wages and salaries $20,000 expected to increase by 3% inflation only at the beginning of the year and then remain constant Depreciation $8,200 expected to stay the same Utilities $7,100 expected to increase by 3% in February and then remain constant Insurance $4,100 expected to increase by 2% on renewal in April and then remain constant Miscellaneous $2,900 expected to stay the same a) Prepare the monthly cost of goods sold budget for 2020. b) Prepare the monthly selling and administrative expenses budget for 2020. c) Prepare the annual budgeted net income statement for 2020, ignoring income taxes based upon the information provided.You have completed the budgets for the production inputs for 2020, summarized below. January February March April May June Direct materials $30,624 $50,945 $75,547 $76,000 $63,230 $50,584 Direct labour $30,019 $49,940 $74,055 $74,499 $61,981 $49,585 Manufacturing overhead $12,615 $20,986 $31, 120 $31,307 $26,046 $20.837 July August September October November | December Direct materials $41,678 $32,772 $29,923 $27,608 $23,867 $22,528 Direct labour $40,855 $32,126 $29,332 $27,062 $23,395 $22,083 Manufacturing overhead $17,169 $13,500 $12,326 $11,372 $ 9,832 $ 9,280 The cost per unit of the open inventory in January is expected to be $705 per unit. You were also provided with the following to use for the selling and administrative budget. Prior-year monthly expense information and assumptions: Shipping costs $45 per unit (no expected change) Wages and salaries $20,000 expected to increase by 3% inflation only at the beginning of the year and then remain constant Depreciation $8,200 expected to stay the same Utilities $7,100 expected to increase by 3% in February and then remain constant Insurance $4,100 expected to increase by 2% on renewal in April and then remain constant Miscellaneous $2,900 expected to stay the same a) Prepare the monthly cost of goods sold budget for 2020. b) Prepare the monthly selling and administrative expenses budget for 2020. c) Prepare the annual budgeted net income statement for 2020, ignoring income taxes based upon the information provided

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

Survey of Accounting

Authors: Carl S. Warren

7th edition

1285974360, 1285183487, 9781285974361, 978-1285183480

Students also viewed these Accounting questions