Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Forecast sales volume and sales budget For 2018, Raphael Frame Company prepared the sales budget that follows. At the end of December 2018, the

image text in transcribedimage text in transcribedimage text in transcribed

Forecast sales volume and sales budget For 2018, Raphael Frame Company prepared the sales budget that follows. At the end of December 2018, the following unit sales data were reported for the year: Unit Sales 8" x 10" Unit Sales 12" x 16" Frame Frame East 25,584 15,750 Central 6,528 6,370 West 5,723 5,406 Raphael Frame Company Sales Budget For the Year Ending December 31, 20YS Unit Sales Unit Selling Product and Area Volume Price Total Sales 8" x 10" Frame: East 24,600 $35 $861,000 Central 6,400 35 224,000 West 5,900 35 206,500 Total 36,900 $1,291,500 12" x 16" Frame: East 15,000 Central 6,500 45 West 5,300 45 $45 $675,000 292,500 238,500 Total Total revenue from sales 26,800 $1,206,000 $2,497,500 For the year ending December 31, 20Y9, unit sales are expected to follow the patterns established during the year ending December 31, 2018. The unit selling price for the 8" x 10" frame is expected to increase to $36 and the unit selling price for the 12" x 16" frame is expected to increase to $47, effective January 1, 2019. Required: 1. Compute the increase or decrease of actual unit sales for the year ended December 31, 2018, over budget. Use the minus sign to indicate a decrease in amount and percent. Round percents to the nearest whole percent. Unit Sales, Increase (Decrease) Year Ended 20Y8 Budget Unit Sales, Year Ended 20Y8 Actual Sales 8" x 10" Frame: Actual Over Increase (Decrease) Actual Over Budget Amount Budget Percent East Central West 12" x 16" Frame: East Central West 111 110 % % % % % % 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 2019, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 2019. Use the minus sign to indicate a decrease in percent. Round budgeted units to the nearest whole unit. 20Y8 Actual Units Percentage Increase (Decrease) 20Y9 Budgeted Units (rounded) 8" x 10" Frame: East Central West 12" x 16" Frame: East Central West 100 000 % % % % % % 000 000 12" x 16" Frame: East Central West 3. Prepare a sales budget for the year ending December 31, 20Y9. Raphael Frame Company Sales Budget For the Year Ending December 31, 20Y9 Unit Unit Sales Selling Volume Price Product and Area Total Sales 8" x 10" Frame: East Central West Total 12" x 16" Frame: East Central West Total Total revenue from sales 000 000 Q % % %

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Accounting Information System

Authors: James A. Hall

7th Edition

978-1439078570, 1439078572

Students also viewed these Accounting questions