Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

1. Compute the increase or decrease of actual unit sales for the year ended Dece

ID: 2497155 • Letter: 1

Question

1. Compute the increase or decrease of actual unit sales for the year ended December 31, 2014, over budget. Use the minus sign to indicate a decrease in amount and percent. Round percents to the nearest whole percent. Unit Sales, Year Ended 2014 Increase (Decrease) Actual Over Budget Budget Actual Sales Percent 8" x 10" Frame: East West 12" x 16" Frame: East West 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) is to continue in 2015, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 2015. Use the minus sign to indicatea decrease in percent. Round budgeted units to the nearest whole unit. 2014 Actual Units Percentage Increase (Decrease) 2015 Budgeted Units (rounded) 8" x 10" Frame: East West 12" x 16" Frame: East West Hide 3. Prepare a sales budget for the year ending December 31, 2015. Guardian Framing Inc. Sales Budget For the Year Ending December 31, 2015 Unit Sales Volume Unit Selling Price Product and Area Total Sales 8" 10" Frame:

Explanation / Answer

1. Compute the increase or decrease of actual unit sales for the year ended December 31, 2014 Unit Sales Increase (Decrease) Year ended 2014 Actual over Budget Budget Actual Difference Percent 8" X 10" Frame     East 28600 29458 858 3.00%     Central 8000 8080 80 1.00%     West 7400 7252 -148 -2.00%    Total 44000 44790 790 1.80% 12" X 16" Frame     East 12200 12688 488 4.00%     Central 2800 2772 -28 -1.00%     West 1800 1854 54 3.00%    Total 16800 17314 514 3.06% 2. Assuming that the increase or decrease in actual sales to budget indicated in part (1) Guardian Framing Inc. Sales Budget For the year ending December 31, 2015 Product and Area Unit sales volume Unit Selling price Total Sales 8" X 10" Frame     East 30342 28 849576     Central 8161 28 228508     West 7107 28 198996    Total 45610 1277080 12" X 16" Frame     East 13196 30 395880     Central 2744 30 82320     West 1910 30 57300    Total 17850 535500                   Total revenue from Sales 1812580