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

THE LINES REPRESENT EMPTY BOXES FOR TOTALS AND THE MAY POST OUT OF LINE but shou

ID: 2375596 • Letter: T

Question

THE LINES REPRESENT EMPTY BOXES FOR TOTALS AND THE MAY POST OUT OF LINE but shouldnt. when u get to E there is suppose to be two lines under october...then two line under nov..then two for december..but totals for every single line..

Rolen, Inc., is in the process of preparing the fourth quarter budget for 2010, and the following data have been assembled:

C Prepare a production budget in units, by month and in total, for the fourth quarter of 2010. (Amounts to be deducted should be indicated with minus sign.)

                                                               
                                                        OCOTOBER              NOVEMBER            DECEMBER        TOTAL

Beginning inventory of finished goods :    _______ ________ ________ ______

units to be produced                  _______ ________                 ________           ______

                                           ________________________________________________________

GOODS available for sale        _______                     ________                 _______         _______

Desired ending inventory of

finished goods (30% of next months

sales budget)                      _______                ________                    ________ ______

Quantity of goods sold         ________                ________                    _________         _______

Prepare a materials purchases budget in pounds, by month and in total, for the fourth quarter of 2010.(Amounts to be deducted should be indicated with minus sign.)

                                                               
                                                         
OCOTOBER              NOVEMBER            DECEMBER      TOTAL

Beginning inventory of raw materials   _______ ________ ______       ______

Purchanses of raw materials             _______ ________ ______         ______

      _________________________________________________________________________

Raw material available for use           ________         ________         ________      ______

Finished goods (40% of next months estimated usage)     ______       ______     ____     _____           

Quanitity of raw materials to be used         
_______ ______        ________ ______
in production

Explanation / Answer

C ) Prepare a production budget in units, by month and in total, for the fourth quarter of 2010. (Amounts to be deducted should be indicated with minus sign.) October November December Total Beginning Inventory of finished good 3240 3780 5400 3240 Unit to be produced 11340 14220 15030 40590 Goods available for sale 14580 18000 20430 43830 Desired Ending inventory of finished good 3780 5400 2430 2430 Quantity of good sold 10800 12600 18000 41400 d) Prepare a materials purchases budget in pounds, by month and in total, for the fourth quarter of 2010.(Amounts to be deducted should be indicated with minus sign.) October November December Total Beginning Inventory of Raw Material 18144 22752 24048 18144 Purchase of raw material 49968 58176 49464 157608 Raw Material available for use 68112 80928 73512 175752 Desired Ending inventory of Raw material 22752 24048 13392 13392 Quantity of raw material to be used in production 45360 56880 60120 162360 e) Prepare a schedule of cash payments for materials, by month and in total, for the fourth quarter of 2010. (Round your answers to the nearest dollar amount. Omit the "$" sign in your response.) Cash Payment for October November December Total September Purchases $    41,018.00 $    41,018.00 October Purchases $ 104,933.00 $    44,971.00 $ 149,904.00 November Purchases $ 122,170.00 $    52,358.00 $ 174,528.00 December Purchases $ 103,874.00 $ 103,874.00 Total Cash Payments $ 145,951.00 $ 167,141.00 $ 156,232.00 $ 469,324.00