Pump Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Pump Manufacturing's operations (Click the icon to view the data.) i (Click the icon to view additional data.) Requirements ghout the budget period. 1. Prepare a schedule of coal collections for January Februsly, and Merch, and for the quarter in total 2. Prepare a production budget. (Hint: Unit sales = Sales in collars (Ecling are per unt. 3. Prepare a decimaterials budget. 4. Prepare a cash peyirierits budget for the cirect material purchased from Requirement 3. 5. Prepare a cash payments budget for conversion costs. 6. Prepare a cash payments budget for operating expenses. 7. Prepare a combined cash budget 2. Calculate the budgeted manufacturing cost per unit. I/.ssume that fixed manufacturing overhead is budgeted to be SO 90 per unit for the year) 9. Prepare a budgeted income statement for the quarter ending March 31. (Hint: Cost of goods solc = Budgeted wost of manufacturing och unit Nurnber of units sold.) 10. Prepare a partial budgeted balance sheet for March 31. Include Laans Payable and Income Tax Payable. Print Dane i Addition des Requirement 1. Prepere a schrecule of cash collections for January, February, and Marchand for the quarter in local. (Round your answers to the nearest whic Pump Manufacturing Cash Collection Budget January February March Quarter Cash sales $ 20,880's 21,800's 22 580's 85.000 Ft Credits sales 57,600 83.520 86.400 227.520 Total cash collections $ 78,480'105,120's 108.980's 292,560 Requirement 2. Prepare a production budget. (Hint: Unt sales = Salcs in dollars Soling price per unit.) Pump Manufacturing Production Budget January February March Quarar Urit sales 8.700 9.000 9400 A Data Table 27,100 990 Plus Desired ending wory 910 910 Total needed 9.8009 9.940 10,310 28,010 Current Assets as of December 21 prior year: Less: Beginning inventory 1870) 19001 (940) (870) S Units to produce 8.730 9040 9,370 27,140 Accounts neochrabie, net $ Requirement 3. Prepare a direct material budget. (Round your answers to the nearest whole dollar. F Irry Property, plant and equipment, net. $ Pump Manufacturing Aphylle Direct Materiais Budget Capital stock $ January February March Quarter FAAT S Urils to be produced 8.730 8,040 8,370 27.140 x kg of DM needed per unit 3 3 Print Done Quantity (kg) needed for production 26,190 27. 120 28.110 81.420 Plus Desired ending inwervary of DM 1,433 9,163 8.163 Total quantity ikg) needed 34,3289 35,863 38,273 89,583 1779 IR 1 17 RATI This question is cornplete. Move your cursor over or tap on the red arrows to see incorrect answer all parts showing 15,800 122,000 42400 9 Actual sales in December were $70.000. Seling price per untis projected to reminlable at $10 per unit throughout the burkulerud. Sales for the first five months of the upcoming year are budguled to be a los January ........ 20.000 February S 92,000 March ..........$ 98,000 Avril ..........S 97,000 May... b. Sales are 255.cachond 74% credt All credit seks are collected in the month following the sale. c Alde Manlluring sa palicy that each monthsanding memory of The good should be 25% of the falowing mont's we in una d. Of conscid crispurs 24 Hor in the metal parco, while bid forint morth Rollwing purch. Two kilograms of direct material de pernil $2.00ng. Ending in enkry af dine materiala should be 10% of xi montits production needs . Marilynberg 55,000 for dery $3.000 laraheldanubecling Rep, $1.20 per unit for variable man.l.ingowed. No depreciation is included in the figura. Al seper And in the martin which they are incred f. Campuluerente de la will be purced in the upcoming querer Inney, Alabamberg will purchase equipment for $5.000 sah, wie February sah expenditure will be $12.000 and Marcha cacah aparire wil ba $1,000 9. Operating emperora gelade $1.00 per un sopla Txes operating a $1,000 per month. Alparsling and paid in the month in which they are incurred. h. Dereticente bubling and were the zealanul ministration alone is bukledis be 35709x the time quarter, which includes cepreciation of new bona Alders Manufacturing a policy that trending caehtoinach month must be at lS4,000 Isle of crede wilson. The concern in$1.000 begining of plastica cubiercing kenalance $150.00. The inarest rate entre la is 15 per month simple interest (not compounded. Alders Manufacturing paracown on the line of credt balance it has execs funds at the end of the quarter. The company also paya the cocumulated interest at the end of the quarter on the funds borrowed during the quarter. i The company income orale i projected to be 305 of operating income sa intenst expense. The company pay $10,000 Ash at the end of February in estimated taxes 126,000 23,100 1.136 Print Done QUAN 2. Prepare a production budget (Hint Unit sales Sales in dollars i Selling price per unit) 3. Prepare a direct materiais budget 4. Prepare a cash payments budget for the direct material purchases fram Requirement 3. 5. Prepare a cash paytinis buugel for conversion costs. 6. Prepare a cash payments budget for operating expenses 7. Prepare a combined cash budget. 8. Caculate the budgeted manufacturing cost per unit. (Asume that fixed manufacturing overhead is budgeled to be $0.90 per unit for the year 9. Prepare a budgeted income statement for the quarter ending March 21. (Hint: Cast of goods sold = Budgeted cost of manufacturing each unit x Number of units cold.) 10. Prepare a partial budgered balance sheet for March 31, Induce Loans Payable and Income Tax Payable 81420 8.159 Print Done 7.8571 27417 Additional data Pump Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Pump Manufacturing's operations: (Click the loon to view the data) 1 (Click the icon to view additional data) Regraments y Hry . Units to be produced 9040 9,370 27.140 x kg of DM madad per unit Quantity ika) needed for production 28 1909 27.120 28,110 Plus: Degradering inventory of DM 8,136 8.433 8.183 Total quantity Ika) needed 34,220 36.653 38,2/3 89,503 Less: Beginning inventory of DM (7.857) (8,136) 184331 Quantity (kg) to purchase 26.460 27340" 81,726 $ x Cost per kg 2.00 $ 2.00 $ 2.00 $ 2.00 $ Total cost of DM purchases $ 52,908's 54.834'$ 55,800's 163,452 Requirement 4. Prepare a cash payments budget for the direct matcrial purchases from Rocuirement. (Le Pump Manufacturing Cash Payments for Direct Material Purchases Budget A Data Table January February March Quarter December purchases (from Accounts Payable) S 42,800.00 S 42,800.00 January purch $ 10,667.60 $42.350.40 " S 52,920.00 Current Assets as of December 31 prior year: February purchases $10.995,00 $ 43,867.20 54,834.00 CH March purchases $ 11,126.00'S 11,120.00 Accounts receivable, et Inventory Total disbursements S 52,267.00 $63.317.20 $ 65,002.20 $ 161,70B.CO Property and equipment Requirements. Prepare a sch payments budget for conversion costs (Round your answers to the nel . Accounts payable Pump Manufacturing Capital stock Fatni hil sarmies Cash Payments for Conversion Costs Budget January February March Quarter Vantable conversion costs $ 9,8035 8,844's 10,307 3 20,854 Print Done Rented 4,500 4,500 4.500 13.500 Other feed MOH 2,000 2.000 2.800 8.400 Tnlal naumants for courrainn noch $ 18,903 $ 17,244's 17,607 3 51,754 This question is complete. Move your cursor over or tap on the red arrows to see incorrect answer 3 4.500 $ 49,000 15,000 122.000 $ $ ..Aduels in December were $70,000 Suling prich peilis praece lo mums abbat $10 per unit throughout the budget period See for the first forth of the upcoming ye budges to be as lolos January ........$ 20,000 $ 99,000 March 20,000 Apri$ 97,000 May$ 25,000 b. Sacs ere 26% osch and 74 credit. Al credit sales are colested in the month following the sale. Alcara Manufacturing policy holes mans ending metery affined goace should be 25% of the filiary marit's sales in urit) d. O each month's direct materal purchases 20% are pad for in the month of purchase, while the remainder is paid for inte morfolore purchase. Two kilograme of direct material is nosced por unit at $2.0ig. Ending inveniory of direct meer als should be 10% of next months procucion needs. e. Morrirly manufacturing conversion costs are $6,000 for factory rent, $3,000 for other fixed manuacturing expenses, and $1.20 per unit for variable mansacturing overcad. No depreciation is included in these figures. All expenses are paid in the month in which they are incurred. 1. Comaar ecument for the Administraties will be purchased in the uscaming quarter. In January, Aldora Mandaluring wil surchase equipment for $5,000 (cash), while February a cash expenditure wil. $12,000 and Marcha cash expenditure wil be $16.00 g. Operating experbariceled to be $1.00 per unit wold pusfied uporsing separes of $1.000 per month. All operating expenses are paid in the tenth in which they are incurred h. Depreciation on the bulding and equipment for the general and administrative offices is budgeted to be $5.700 for the entire quarter, which includes cepreciation on new acquisitions 1 Acer Manufacturing has a policy that the ending cash baiance in each month must be at last $4,000. It has a line of credit with local bank. The company can borrow in increments of $1.000 at the beginning of each month, up to a total outstanding loan balance of $150.can. The interest rate on these laana la 1% per month simple interest (not compounded) Alcara Manfacturing nya cown an the Ine of credit balance it has excesunds at the end of the quarter. The company also pay the accumulated interest at the end of the cuarter on the funds borrowed during the quarter. The pH rates pret 31% of pering i Hp The cocony pay $10,000 Both of February in die HEHK 42,400 126 000 28,100 $ l i Requirements 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in bora 2. Prepare a production budget. (Hint: Unit Sales - Sales in dolars/ Seling price per unit) 3. Prepare a direct materials budget 4. Prepare a cash payments budget for the dret material purchases from Requirement 2. 5. Prepare a cash payments budget for conversion costs. G. Prepare a cash payments budget for operating experses. 7. Prepare a combined cash budget 8. Calculate the budgeted manufacturing cost per unit (ASSUMA That fed manufachering overhead is budgeten to be $0.90 per unit for the year.) 9. Pregere a budgeted income statement for the quarter ercing March 31. (Hint Cost of goods sold - Budgeted cost of manufacturing each unit x Number of units sold.) 10. Prepare a partial bucgeled balance sheet for March 31. Irclude Lueris Payable and Income Tax Payable Print Done i Auditiraleta Score: 0 of 1 pt 1 of 1 (1 complete Pump Manufacturing Cash Payments for Operating Expenses Budget January February March Quarter Variable operating expenses $ 11,3105 11.700 $ 12.220 35,230 Fixed operating expenses 1.800 1.800 5,400 13,110' 5 13.500 Total payments for operating expenses 14,020 40,630 Requirement 7. Prepere a combined cash budget (Leave any unused cells blank. Use parentheses or a minus sign for negative cash balances and finan Pump Manufacturing Combined Cash Budget January Fahruary March Quarter Cual balance beginning $ 4.640.00 $ 4.719.40 $ 5,178 20 $ 4.840.00 Add cash colectione 78,480.00 105,120.00 108,56000 292,500.00 Tolles gaible 83,120.00 109 839.40 114,138 20297,200.00 Less cash disbursements: Druci material purchases $53.387.60 53.317.20 55,000 20 161.708.00 Conversion costs 16,902.00 17.244.00 17,607 00 51,754.00 Operating expenses 13,110,00 13,500.00 14,020.00 40.830.00 0 Dal Table Equipment purchase 6.000.00 12800.00 15,600.00 34 400.00 Tax payment 10 800.00 10,000.00 $89.400.60 Total payments 107 651.20 Current Assets of Ceceber 31 por un 102,730 20 290,202.00 Cash { 6280.60) 2.178.20 Exces deliciency of cash 11,308 00 -2,092.00 Accounts Financing: inventory Borrowings 11.000.00 3,000.00 14.000.00 Property plant and men, nel Ariyabi 16090.con Repaytrens 16,000.00 Child Interest payments (790.00 780.00) Total financing 11,000.00 3,000.00 16.790.00) 7,220.00 Ending cash balance $ 4,719.40 $ 5.178.20 $ 5,128.00 $ 5,128.00 Print Donc 4.500 19.000 $ $ 15,800 5 $ $ 122.000 42.400 12H000 22,100 a Actual aks le December were $70,000 Seling price per un is rejected to remain stable at $10 per unit throughouthe budyw. pl. diffimulac OS WIN bulalas no HICHO Futy.......$ 9.000 March ....... 60.000 April .........T.CO $ 97.000 $ CU h. Se amesh and 14% Alle Ted in the menting the 4. Ada Wauliduring policy illalla cachmend dinginery and good head Le 25 of the Sada onun d. Ofer month dret metal purchases, 20% are paid for in the month or purchase. while the remainder is cald forinto met wat die Here $2.0.by. Erding into a divertid should be 10% of next month's production needs. Melontar con CSS 000 krickory rent. So far the firsturingspers and $123 perunt for variable manufacturing omhed. No cepreciation is included in the figures. Al us are paid in the month in width 1. Computercument for the administrative ofices will be purchased in the upcoming quarter. Inanay Alders Men facturing wil percorsquen fors.00 h, when Fryders with $12.000 tl's EMC wil be $10,000. 9. Og budget and his feet perling pent of $1.00 per month Alopersing are pels in the morth in woh they are inomed. quarter, which includes deporo wa usions. Depreciation on the building and equipment for the general and ad-inistre uticos is budged to be $5.700 for the entire L Alders Marufacturing has a poley that the ending cash balance in each month must be at least 54.000. It has a ine of credit wilt kolbank. The company can be increase $1.000 begrigach mal loatelacancir Irunbalance $150.000. The interest rain on these ans 1 parmorih emple meme nel compounded Aiders Manufacturing para cum on the line of credit belance if it has xoc funds the end of the quarter. The company ako para hubieral al Ander Ihren .nex bering the i The concert/a con projected to be 20% cepumuling iilures exer. The county pupa 30.000 cash the end of February in si maled as This question is complete. Move your cursor over or tap on the red arrows 10 868 incorrect answers, 1 All parts showing Print Care Tirar a a direct - / ) Score: 0 of 1 pt 1 of 1 11 compli Requirement 3. Calculate the budgeted manutatuning cos por unt (Assume that fixed martacturing overhead is budgeted to be $0.70 per unit for the year 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. 2. Prepare a production budget (Hint Unit sales - Sales in dolars! Selling price per unit) Pump Manufacturing a Budgeted Manufacturing Cost per Unit 4. Prepare a cash paymeril budget for the direct material purchases from Requirement 3. 5. Prepare a cash payments budget for conversion costs Dract materials sont par unit 3 6. Prepare a cash payments budget for aperating expenses. Conversion as per unil 7. Prepare a combined cash budgol. 1.10 8. Calculate the budgeted manufacturing coat per unit (Assume that fixed manufacturing overhead is budgeted Fiesc manufacturing overhead per unit 0.70 sa ho So.10 par unit for the year) 9. Prepare a budgeted income statement for the quarter ending March 31. (Hint: Cast of goods sold - Budgeted 3 7.30 Budgeted cost of manufacturing cach unit asl of manufacturing each unt. Nurber of units sold.) 10. Prepare a partial budgehad balance sheet for March 31 Include lana Payable and Income Tax Payable , Requirement 9. Prepare a budgeted income statement for the quarter ending March 31. (Hint: Cost of goods sold = Budga Pump Manufacturing o Print Done Budgeted Income Statement For the Quarter Ending March 31 Sales $325.200 i ) Additional de Cost of goods sold Gruss profil 113 820 Operating expenses a. Actual sales in December were 70,000. Saling price per unit is proiected to remain stable at $10 perunt throughout the budel period forte frumore ofte eming year budget wax fox Deprecation expense January ....... 39,020 330,020 Operating income 67.490 i Data Table February ........592,00 Less interest expensa (780) Warch .........509,000 Less provision for Income taxes April ..........3 97,000 Orrinese CHE 31 Net income Way........... 05,000 C b. Sacs are 25% cash and 74 credit. Al credt sales are colected in the month following the sale. Requirement 10. Prepare a partial budgeted halans short for March 31. Include Laana Payable and Income Tax Payable A 3 49,000 Alcers Manufacturing has a policy that states that each mont's ending invencry cliniched goods should be 25% of the following mont's sales in uns. Inventory S 16,600 d. Of each month's drect malarial purchases, 20% are paid for in the month of purchase, while the remainder is paid for in the Pump Manufacturing Property, plant, and equioment, net. S $ 122.000 mandoline purcs. Two ingrata per $2.g. Erding immer med Partial Budgeted Balance Statement should be 10% of next month's production needs. Acoounos payable $ 42.400 e Monthly marutscturing conversion 606% are $5,000 for factory or 1,000 for one wed manucuring expenses, and $12 March 31 Captal clock 126.0CO er uit for winged No deixin in the curra. Alp At paid in the earth which they are incurred Cash $ $ 5.129 Relained aminos 23.100 1. Computer equiment for the administrateches all be purchased in the upcoming quarter. In anuary, Alders Manufacturer wil und or $5.COD coatik Fachperdure will be $12,000 and Mardin 80210 Accounts recevable, net $16.000 Print Done 9. Opera ng esperar budged to be $100 per unted plus and operating expenses of $1.000 per month Al operating $ experkine months in wrich they are incred This question is complete. Move your cursor over or tap on the red arrows to see incorrect answers h. Depreciation on the buicing and equipment for the general and admin sathe offices budgosed to be 55,700 for the endre quarter, which include depression on win All parts showing i Alexandring i pericytotending times itachmarhill 34,600. It was in of with a local bank. The company can banow in increments of 31.000 at 1c xginning of cach month up to a tal outstanding Bertalana of $150.000 The lead role contestark is 15 jerment de l'estrul comune : Allers Manufacturing pays down on the line of credit balance it it has excess funds at the end of the quarter the company clso pay accumulated interest the end of the quarter on the funds red during the quarter The company's Talispetto al operating in Hip Thappy $10.00 cash alte end of February in esimied taxes. 1211,3801 (40,83001 (5.700) (20.019) $ 46 ART 3 $ For the Quarler Ercing March 31 | Sales $325200 (21 380) 113.20 Cost of goods sold Gross proft Operating expenses Depreciation espere Operating income Less: intarest expansia Less: provision for income taxes 15,700) 67 4999 1780) 20.013) $ 46,897 1. Prepare a schedule of cash collections for January February, and March, and for the quarter instal 2. Prepare a product on budget (Hint Unit sales - Sale in collar/Selling price per unit.) 3. Prepare a direct materiale get 4. Preciare a cash payments budget for the direct material purchase from Requirements 5. Prepare a cash payments budget for conversion costs. 6. Prepare a cash payments burgol for operating expenses. 7. Prepare a combined cash budget 8. Calculate the budgeted manufacturing cost per unit. Assume that fixec manufacturing overhead is budgeted to be 50.00 per unit for the year) 9. Prepare a budgeted income statement for the quarter ending March 31. (Hint: Cost of goods sold = Budgeted bos. of manufacturing each unitx Number of units sol.) 10. Prepare a partial budgeted balance sheet for March 31. Include Lara Payable and Income Tax Payable Net Income e Print Dane i Arti Requirement 10. Prepare a partial budgeted belance sheet for March 31, Incuce Loans Payable and Income Tax Payet Pump Manufacturing Partial Budgeted Balance Statement March 31 s 5.123 Accounts receivable, nel 90.240 Inventory Property, plan and equipment, nel Accounts payable 44.544 Income tax payable Financing perable Caprial stock 124 000 Relsined earrings 69.897 a Actual sales in December were 570.000. Selling priceperunt is projected to remain slable at $10 per un throughout the parklers from all G H bucja la la la January $ 30,000 February $ 200 149 0 Date Table 92129 $ 4,500 5 $ DHEA Hof Dec 31 (i yek Call Accounts receivable.net Ivory Pripbandel, , Accounts payable Capital sock Relained earning $ 49.000 15800 122,000 42400 120.000 23.100 This question is complete. Move your cursor over or tap on the red arrows to see incorrect answers, 5 All parts showing Apl ....... 97,000 Way... 05,000 b. Sales are 20% casa and 74credt. Al credt sales are clected in the month following the sale Nang policy that the man wingery first goede shots of the clowing that in d. Oleh menciptand 2016 for in the mental purchase, while I wipid for in the month followtrg purchase. Two Blograms of direct maioral nocded perunt at $200 g. Ending motory of direct materials should a 10. cel mai cores . Monthly manufacturing conversion costs are 55,000 for Poetry ren, 53,000 for other red manufacturing exccnoes and 512 HEREVATING.ringer Nasioni che non figures ACX TH plinthe which they are incurcd t. Comprar oupant for the wmnsra vores will be din upang gurtin.bancary. Alders Warung wil purchase equipment for $5.000 cash, while February's cash cxpendture will be $12,000 and Marchs cash cxpenditure will TOO . Die BEDRI but be $1.00 ed Alucard pay $1,000 Pred. All open sypances are paid in the mort in which they are curred h. Dwa bungan Info GRAN letnici Elette $5.700 ferite quarter, which noludes depreciation on now acquls tions. 1. Allschungspolicy to the ding cash bad met mest beat $1.000 i sin of crear with a local bank. The company can borrow in nine mets of $1.000 arthe beginning of each month up to a local outstanding CHO $150.000 The incredere per le monde Alchi Wanufacuring pays down on the Inc of credt balance has choces funds at the end of the quarter. The company also pays ..Elcinlere do te ndalur H. . The company's income tax role is projected to be 30% of opcraing income casinlerck expense. The company pays $10,000 ceshat the door Print Cene Pump Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Pump Manufacturing's operations (Click the icon to view the data.) i (Click the icon to view additional data.) Requirements ghout the budget period. 1. Prepare a schedule of coal collections for January Februsly, and Merch, and for the quarter in total 2. Prepare a production budget. (Hint: Unit sales = Sales in collars (Ecling are per unt. 3. Prepare a decimaterials budget. 4. Prepare a cash peyirierits budget for the cirect material purchased from Requirement 3. 5. Prepare a cash payments budget for conversion costs. 6. Prepare a cash payments budget for operating expenses. 7. Prepare a combined cash budget 2. Calculate the budgeted manufacturing cost per unit. I/.ssume that fixed manufacturing overhead is budgeted to be SO 90 per unit for the year) 9. Prepare a budgeted income statement for the quarter ending March 31. (Hint: Cost of goods solc = Budgeted wost of manufacturing och unit Nurnber of units sold.) 10. Prepare a partial budgeted balance sheet for March 31. Include Laans Payable and Income Tax Payable. Print Dane i Addition des Requirement 1. Prepere a schrecule of cash collections for January, February, and Marchand for the quarter in local. (Round your answers to the nearest whic Pump Manufacturing Cash Collection Budget January February March Quarter Cash sales $ 20,880's 21,800's 22 580's 85.000 Ft Credits sales 57,600 83.520 86.400 227.520 Total cash collections $ 78,480'105,120's 108.980's 292,560 Requirement 2. Prepare a production budget. (Hint: Unt sales = Salcs in dollars Soling price per unit.) Pump Manufacturing Production Budget January February March Quarar Urit sales 8.700 9.000 9400 A Data Table 27,100 990 Plus Desired ending wory 910 910 Total needed 9.8009 9.940 10,310 28,010 Current Assets as of December 21 prior year: Less: Beginning inventory 1870) 19001 (940) (870) S Units to produce 8.730 9040 9,370 27,140 Accounts neochrabie, net $ Requirement 3. Prepare a direct material budget. (Round your answers to the nearest whole dollar. F Irry Property, plant and equipment, net. $ Pump Manufacturing Aphylle Direct Materiais Budget Capital stock $ January February March Quarter FAAT S Urils to be produced 8.730 8,040 8,370 27.140 x kg of DM needed per unit 3 3 Print Done Quantity (kg) needed for production 26,190 27. 120 28.110 81.420 Plus Desired ending inwervary of DM 1,433 9,163 8.163 Total quantity ikg) needed 34,3289 35,863 38,273 89,583 1779 IR 1 17 RATI This question is cornplete. Move your cursor over or tap on the red arrows to see incorrect answer all parts showing 15,800 122,000 42400 9 Actual sales in December were $70.000. Seling price per untis projected to reminlable at $10 per unit throughout the burkulerud. Sales for the first five months of the upcoming year are budguled to be a los January ........ 20.000 February S 92,000 March ..........$ 98,000 Avril ..........S 97,000 May... b. Sales are 255.cachond 74% credt All credit seks are collected in the month following the sale. c Alde Manlluring sa palicy that each monthsanding memory of The good should be 25% of the falowing mont's we in una d. Of conscid crispurs 24 Hor in the metal parco, while bid forint morth Rollwing purch. Two kilograms of direct material de pernil $2.00ng. Ending in enkry af dine materiala should be 10% of xi montits production needs . Marilynberg 55,000 for dery $3.000 laraheldanubecling Rep, $1.20 per unit for variable man.l.ingowed. No depreciation is included in the figura. Al seper And in the martin which they are incred f. Campuluerente de la will be purced in the upcoming querer Inney, Alabamberg will purchase equipment for $5.000 sah, wie February sah expenditure will be $12.000 and Marcha cacah aparire wil ba $1,000 9. Operating emperora gelade $1.00 per un sopla Txes operating a $1,000 per month. Alparsling and paid in the month in which they are incurred. h. Dereticente bubling and were the zealanul ministration alone is bukledis be 35709x the time quarter, which includes cepreciation of new bona Alders Manufacturing a policy that trending caehtoinach month must be at lS4,000 Isle of crede wilson. The concern in$1.000 begining of plastica cubiercing kenalance $150.00. The inarest rate entre la is 15 per month simple interest (not compounded. Alders Manufacturing paracown on the line of credt balance it has execs funds at the end of the quarter. The company also paya the cocumulated interest at the end of the quarter on the funds borrowed during the quarter. i The company income orale i projected to be 305 of operating income sa intenst expense. The company pay $10,000 Ash at the end of February in estimated taxes 126,000 23,100 1.136 Print Done QUAN 2. Prepare a production budget (Hint Unit sales Sales in dollars i Selling price per unit) 3. Prepare a direct materiais budget 4. Prepare a cash payments budget for the direct material purchases fram Requirement 3. 5. Prepare a cash paytinis buugel for conversion costs. 6. Prepare a cash payments budget for operating expenses 7. Prepare a combined cash budget. 8. Caculate the budgeted manufacturing cost per unit. (Asume that fixed manufacturing overhead is budgeled to be $0.90 per unit for the year 9. Prepare a budgeted income statement for the quarter ending March 21. (Hint: Cast of goods sold = Budgeted cost of manufacturing each unit x Number of units cold.) 10. Prepare a partial budgered balance sheet for March 31, Induce Loans Payable and Income Tax Payable 81420 8.159 Print Done 7.8571 27417 Additional data Pump Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Pump Manufacturing's operations: (Click the loon to view the data) 1 (Click the icon to view additional data) Regraments y Hry . Units to be produced 9040 9,370 27.140 x kg of DM madad per unit Quantity ika) needed for production 28 1909 27.120 28,110 Plus: Degradering inventory of DM 8,136 8.433 8.183 Total quantity Ika) needed 34,220 36.653 38,2/3 89,503 Less: Beginning inventory of DM (7.857) (8,136) 184331 Quantity (kg) to purchase 26.460 27340" 81,726 $ x Cost per kg 2.00 $ 2.00 $ 2.00 $ 2.00 $ Total cost of DM purchases $ 52,908's 54.834'$ 55,800's 163,452 Requirement 4. Prepare a cash payments budget for the direct matcrial purchases from Rocuirement. (Le Pump Manufacturing Cash Payments for Direct Material Purchases Budget A Data Table January February March Quarter December purchases (from Accounts Payable) S 42,800.00 S 42,800.00 January purch $ 10,667.60 $42.350.40 " S 52,920.00 Current Assets as of December 31 prior year: February purchases $10.995,00 $ 43,867.20 54,834.00 CH March purchases $ 11,126.00'S 11,120.00 Accounts receivable, et Inventory Total disbursements S 52,267.00 $63.317.20 $ 65,002.20 $ 161,70B.CO Property and equipment Requirements. Prepare a sch payments budget for conversion costs (Round your answers to the nel . Accounts payable Pump Manufacturing Capital stock Fatni hil sarmies Cash Payments for Conversion Costs Budget January February March Quarter Vantable conversion costs $ 9,8035 8,844's 10,307 3 20,854 Print Done Rented 4,500 4,500 4.500 13.500 Other feed MOH 2,000 2.000 2.800 8.400 Tnlal naumants for courrainn noch $ 18,903 $ 17,244's 17,607 3 51,754 This question is complete. Move your cursor over or tap on the red arrows to see incorrect answer 3 4.500 $ 49,000 15,000 122.000 $ $ ..Aduels in December were $70,000 Suling prich peilis praece lo mums abbat $10 per unit throughout the budget period See for the first forth of the upcoming ye budges to be as lolos January ........$ 20,000 $ 99,000 March 20,000 Apri$ 97,000 May$ 25,000 b. Sacs ere 26% osch and 74 credit. Al credit sales are colested in the month following the sale. Alcara Manufacturing policy holes mans ending metery affined goace should be 25% of the filiary marit's sales in urit) d. O each month's direct materal purchases 20% are pad for in the month of purchase, while the remainder is paid for inte morfolore purchase. Two kilograme of direct material is nosced por unit at $2.0ig. Ending inveniory of direct meer als should be 10% of next months procucion needs. e. Morrirly manufacturing conversion costs are $6,000 for factory rent, $3,000 for other fixed manuacturing expenses, and $1.20 per unit for variable mansacturing overcad. No depreciation is included in these figures. All expenses are paid in the month in which they are incurred. 1. Comaar ecument for the Administraties will be purchased in the uscaming quarter. In January, Aldora Mandaluring wil surchase equipment for $5,000 (cash), while February a cash expenditure wil. $12,000 and Marcha cash expenditure wil be $16.00 g. Operating experbariceled to be $1.00 per unit wold pusfied uporsing separes of $1.000 per month. All operating expenses are paid in the tenth in which they are incurred h. Depreciation on the bulding and equipment for the general and administrative offices is budgeted to be $5.700 for the entire quarter, which includes cepreciation on new acquisitions 1 Acer Manufacturing has a policy that the ending cash baiance in each month must be at last $4,000. It has a line of credit with local bank. The company can borrow in increments of $1.000 at the beginning of each month, up to a total outstanding loan balance of $150.can. The interest rate on these laana la 1% per month simple interest (not compounded) Alcara Manfacturing nya cown an the Ine of credit balance it has excesunds at the end of the quarter. The company also pay the accumulated interest at the end of the cuarter on the funds borrowed during the quarter. The pH rates pret 31% of pering i Hp The cocony pay $10,000 Both of February in die HEHK 42,400 126 000 28,100 $ l i Requirements 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in bora 2. Prepare a production budget. (Hint: Unit Sales - Sales in dolars/ Seling price per unit) 3. Prepare a direct materials budget 4. Prepare a cash payments budget for the dret material purchases from Requirement 2. 5. Prepare a cash payments budget for conversion costs. G. Prepare a cash payments budget for operating experses. 7. Prepare a combined cash budget 8. Calculate the budgeted manufacturing cost per unit (ASSUMA That fed manufachering overhead is budgeten to be $0.90 per unit for the year.) 9. Pregere a budgeted income statement for the quarter ercing March 31. (Hint Cost of goods sold - Budgeted cost of manufacturing each unit x Number of units sold.) 10. Prepare a partial bucgeled balance sheet for March 31. Irclude Lueris Payable and Income Tax Payable Print Done i Auditiraleta Score: 0 of 1 pt 1 of 1 (1 complete Pump Manufacturing Cash Payments for Operating Expenses Budget January February March Quarter Variable operating expenses $ 11,3105 11.700 $ 12.220 35,230 Fixed operating expenses 1.800 1.800 5,400 13,110' 5 13.500 Total payments for operating expenses 14,020 40,630 Requirement 7. Prepere a combined cash budget (Leave any unused cells blank. Use parentheses or a minus sign for negative cash balances and finan Pump Manufacturing Combined Cash Budget January Fahruary March Quarter Cual balance beginning $ 4.640.00 $ 4.719.40 $ 5,178 20 $ 4.840.00 Add cash colectione 78,480.00 105,120.00 108,56000 292,500.00 Tolles gaible 83,120.00 109 839.40 114,138 20297,200.00 Less cash disbursements: Druci material purchases $53.387.60 53.317.20 55,000 20 161.708.00 Conversion costs 16,902.00 17.244.00 17,607 00 51,754.00 Operating expenses 13,110,00 13,500.00 14,020.00 40.830.00 0 Dal Table Equipment purchase 6.000.00 12800.00 15,600.00 34 400.00 Tax payment 10 800.00 10,000.00 $89.400.60 Total payments 107 651.20 Current Assets of Ceceber 31 por un 102,730 20 290,202.00 Cash { 6280.60) 2.178.20 Exces deliciency of cash 11,308 00 -2,092.00 Accounts Financing: inventory Borrowings 11.000.00 3,000.00 14.000.00 Property plant and men, nel Ariyabi 16090.con Repaytrens 16,000.00 Child Interest payments (790.00 780.00) Total financing 11,000.00 3,000.00 16.790.00) 7,220.00 Ending cash balance $ 4,719.40 $ 5.178.20 $ 5,128.00 $ 5,128.00 Print Donc 4.500 19.000 $ $ 15,800 5 $ $ 122.000 42.400 12H000 22,100 a Actual aks le December were $70,000 Seling price per un is rejected to remain stable at $10 per unit throughouthe budyw. pl. diffimulac OS WIN bulalas no HICHO Futy.......$ 9.000 March ....... 60.000 April .........T.CO $ 97.000 $ CU h. Se amesh and 14% Alle Ted in the menting the 4. Ada Wauliduring policy illalla cachmend dinginery and good head Le 25 of the Sada onun d. Ofer month dret metal purchases, 20% are paid for in the month or purchase. while the remainder is cald forinto met wat die Here $2.0.by. Erding into a divertid should be 10% of next month's production needs. Melontar con CSS 000 krickory rent. So far the firsturingspers and $123 perunt for variable manufacturing omhed. No cepreciation is included in the figures. Al us are paid in the month in width 1. Computercument for the administrative ofices will be purchased in the upcoming quarter. Inanay Alders Men facturing wil percorsquen fors.00 h, when Fryders with $12.000 tl's EMC wil be $10,000. 9. Og budget and his feet perling pent of $1.00 per month Alopersing are pels in the morth in woh they are inomed. quarter, which includes deporo wa usions. Depreciation on the building and equipment for the general and ad-inistre uticos is budged to be $5.700 for the entire L Alders Marufacturing has a poley that the ending cash balance in each month must be at least 54.000. It has a ine of credit wilt kolbank. The company can be increase $1.000 begrigach mal loatelacancir Irunbalance $150.000. The interest rain on these ans 1 parmorih emple meme nel compounded Aiders Manufacturing para cum on the line of credit belance if it has xoc funds the end of the quarter. The company ako para hubieral al Ander Ihren .nex bering the i The concert/a con projected to be 20% cepumuling iilures exer. The county pupa 30.000 cash the end of February in si maled as This question is complete. Move your cursor over or tap on the red arrows 10 868 incorrect answers, 1 All parts showing Print Care Tirar a a direct - / ) Score: 0 of 1 pt 1 of 1 11 compli Requirement 3. Calculate the budgeted manutatuning cos por unt (Assume that fixed martacturing overhead is budgeted to be $0.70 per unit for the year 1. Prepare a schedule of cash collections for January, February, and March, and for the quarter in total. 2. Prepare a production budget (Hint Unit sales - Sales in dolars! Selling price per unit) Pump Manufacturing a Budgeted Manufacturing Cost per Unit 4. Prepare a cash paymeril budget for the direct material purchases from Requirement 3. 5. Prepare a cash payments budget for conversion costs Dract materials sont par unit 3 6. Prepare a cash payments budget for aperating expenses. Conversion as per unil 7. Prepare a combined cash budgol. 1.10 8. Calculate the budgeted manufacturing coat per unit (Assume that fixed manufacturing overhead is budgeted Fiesc manufacturing overhead per unit 0.70 sa ho So.10 par unit for the year) 9. Prepare a budgeted income statement for the quarter ending March 31. (Hint: Cast of goods sold - Budgeted 3 7.30 Budgeted cost of manufacturing cach unit asl of manufacturing each unt. Nurber of units sold.) 10. Prepare a partial budgehad balance sheet for March 31 Include lana Payable and Income Tax Payable , Requirement 9. Prepare a budgeted income statement for the quarter ending March 31. (Hint: Cost of goods sold = Budga Pump Manufacturing o Print Done Budgeted Income Statement For the Quarter Ending March 31 Sales $325.200 i ) Additional de Cost of goods sold Gruss profil 113 820 Operating expenses a. Actual sales in December were 70,000. Saling price per unit is proiected to remain stable at $10 perunt throughout the budel period forte frumore ofte eming year budget wax fox Deprecation expense January ....... 39,020 330,020 Operating income 67.490 i Data Table February ........592,00 Less interest expensa (780) Warch .........509,000 Less provision for Income taxes April ..........3 97,000 Orrinese CHE 31 Net income Way........... 05,000 C b. Sacs are 25% cash and 74 credit. Al credt sales are colected in the month following the sale. Requirement 10. Prepare a partial budgeted halans short for March 31. Include Laana Payable and Income Tax Payable A 3 49,000 Alcers Manufacturing has a policy that states that each mont's ending invencry cliniched goods should be 25% of the following mont's sales in uns. Inventory S 16,600 d. Of each month's drect malarial purchases, 20% are paid for in the month of purchase, while the remainder is paid for in the Pump Manufacturing Property, plant, and equioment, net. S $ 122.000 mandoline purcs. Two ingrata per $2.g. Erding immer med Partial Budgeted Balance Statement should be 10% of next month's production needs. Acoounos payable $ 42.400 e Monthly marutscturing conversion 606% are $5,000 for factory or 1,000 for one wed manucuring expenses, and $12 March 31 Captal clock 126.0CO er uit for winged No deixin in the curra. Alp At paid in the earth which they are incurred Cash $ $ 5.129 Relained aminos 23.100 1. Computer equiment for the administrateches all be purchased in the upcoming quarter. In anuary, Alders Manufacturer wil und or $5.COD coatik Fachperdure will be $12,000 and Mardin 80210 Accounts recevable, net $16.000 Print Done 9. Opera ng esperar budged to be $100 per unted plus and operating expenses of $1.000 per month Al operating $ experkine months in wrich they are incred This question is complete. Move your cursor over or tap on the red arrows to see incorrect answers h. Depreciation on the buicing and equipment for the general and admin sathe offices budgosed to be 55,700 for the endre quarter, which include depression on win All parts showing i Alexandring i pericytotending times itachmarhill 34,600. It was in of with a local bank. The company can banow in increments of 31.000 at 1c xginning of cach month up to a tal outstanding Bertalana of $150.000 The lead role contestark is 15 jerment de l'estrul comune : Allers Manufacturing pays down on the line of credit balance it it has excess funds at the end of the quarter the company clso pay accumulated interest the end of the quarter on the funds red during the quarter The company's Talispetto al operating in Hip Thappy $10.00 cash alte end of February in esimied taxes. 1211,3801 (40,83001 (5.700) (20.019) $ 46 ART 3 $ For the Quarler Ercing March 31 | Sales $325200 (21 380) 113.20 Cost of goods sold Gross proft Operating expenses Depreciation espere Operating income Less: intarest expansia Less: provision for income taxes 15,700) 67 4999 1780) 20.013) $ 46,897 1. Prepare a schedule of cash collections for January February, and March, and for the quarter instal 2. Prepare a product on budget (Hint Unit sales - Sale in collar/Selling price per unit.) 3. Prepare a direct materiale get 4. Preciare a cash payments budget for the direct material purchase from Requirements 5. Prepare a cash payments budget for conversion costs. 6. Prepare a cash payments burgol for operating expenses. 7. Prepare a combined cash budget 8. Calculate the budgeted manufacturing cost per unit. Assume that fixec manufacturing overhead is budgeted to be 50.00 per unit for the year) 9. Prepare a budgeted income statement for the quarter ending March 31. (Hint: Cost of goods sold = Budgeted bos. of manufacturing each unitx Number of units sol.) 10. Prepare a partial budgeted balance sheet for March 31. Include Lara Payable and Income Tax Payable Net Income e Print Dane i Arti Requirement 10. Prepare a partial budgeted belance sheet for March 31, Incuce Loans Payable and Income Tax Payet Pump Manufacturing Partial Budgeted Balance Statement March 31 s 5.123 Accounts receivable, nel 90.240 Inventory Property, plan and equipment, nel Accounts payable 44.544 Income tax payable Financing perable Caprial stock 124 000 Relsined earrings 69.897 a Actual sales in December were 570.000. Selling priceperunt is projected to remain slable at $10 per un throughout the parklers from all G H bucja la la la January $ 30,000 February $ 200 149 0 Date Table 92129 $ 4,500 5 $ DHEA Hof Dec 31 (i yek Call Accounts receivable.net Ivory Pripbandel, , Accounts payable Capital sock Relained earning $ 49.000 15800 122,000 42400 120.000 23.100 This question is complete. Move your cursor over or tap on the red arrows to see incorrect answers, 5 All parts showing Apl ....... 97,000 Way... 05,000 b. Sales are 20% casa and 74credt. Al credt sales are clected in the month following the sale Nang policy that the man wingery first goede shots of the clowing that in d. Oleh menciptand 2016 for in the mental purchase, while I wipid for in the month followtrg purchase. Two Blograms of direct maioral nocded perunt at $200 g. Ending motory of direct materials should a 10. cel mai cores . Monthly manufacturing conversion costs are 55,000 for Poetry ren, 53,000 for other red manufacturing exccnoes and 512 HEREVATING.ringer Nasioni che non figures ACX TH plinthe which they are incurcd t. Comprar oupant for the wmnsra vores will be din upang gurtin.bancary. Alders Warung wil purchase equipment for $5.000 cash, while February's cash cxpendture will be $12,000 and Marchs cash cxpenditure will TOO . Die BEDRI but be $1.00 ed Alucard pay $1,000 Pred. All open sypances are paid in the mort in which they are curred h. Dwa bungan Info GRAN letnici Elette $5.700 ferite quarter, which noludes depreciation on now acquls tions. 1. Allschungspolicy to the ding cash bad met mest beat $1.000 i sin of crear with a local bank. The company can borrow in nine mets of $1.000 arthe beginning of each month up to a local outstanding CHO $150.000 The incredere per le monde Alchi Wanufacuring pays down on the Inc of credt balance has choces funds at the end of the quarter. The company also pays ..Elcinlere do te ndalur H. . The company's income tax role is projected to be 30% of opcraing income casinlerck expense. The company pays $10,000 ceshat the door Print Cene
