Write only the amount needed. Do not write Peso sign or P to indicate peso value. Use the PARENTHESES symbol () to denote negative values. Use comma (if necessary) when writing values. Round off your final answer to the nearest whole number.Please answer everything ASAP. I really need help Problem Set 2. Production BudgetProduction BudgetMary's Coffee Shop has to compute for the sales budget ofthe operation from the January to March 2019. The shopoffers flavored coffee: cappuccino, mocha, latte and brewedcoffee which are sold at P75.00, P72.00, P80.00 and P60.00per serving (in cups) respectively. The following data showsanticipated volume of sales (in cups) during the first quarter.ItemJanuaryMarchFebruaryCappuccino150200195Mocha10012090Latte80110115Brewed1751501802611 M.A.2829N.30. Answer to cell E.31. Answer to cell F.32. Answer to cell G.33. Answer to cell H.34. Answer to cell O.35. Answer to cell I.36. Answer to cell J.37. Answer to cell K.38. Answer to cell L.ActGoPrepare the monthly schedule of production budget of Mary'sCoffee Shop. The inventory of the shop is estimated asfollows.ItemEndingBeginningInventory (units) Inventory (units)CappuccinoMochaLatteBrewedEnding and beginning inventory are expected to increase by2% and 1% for the month of February and Marchrespectively. Use table to show your answer.50251540Compute the production budget for the month of January to March.ItemUnits to be soldAdd: Desired ending inventoryTotalLess: Beginning inventoryUnits to be produced60502550JanuaryMABFebruaryNEFGHMarchOIJ

The sales forecast and the anticipated amount of finished goods inventory to be on hand are combined…

Production Budget Mary's Coffee Shop has to compute for the sales budget of the operation from the January to March 2019. The shop offers flavored coffee: cappuccino, mocha, latte and brewed coffee which are sold at P75.00, P72.00, P80.00 and P60.00 per serving (in cups) respectively. The following data shows anticipated volume of sales (in cups) during the first quarter. Item January March February Cappuccino 150 200 195 100 120 90 80 110 115 175 150 180 Mocha Latte Brewed Act Go Prepare the monthly schedule of production budget of Mary's Coffee Shop. The inventory of the shop is estimated as follows. Item Ending Inventory (units) Cappuccino Mocha Latte Brewed Ending and beginning inventory are expected to increase by 2% and 1% for the month of February and March respectively. Use table to show your answer. 50 25 15 40 Beginning Inventory (units) Item Units to be sold Add: Desired ending inventory Total Less: Beginning inventory Units to be produced Compute the production budget for the month of January to March. January M А ABCD 60 50 с 25 50 February N E F G H March O I J K L

Production Budget Mary's Coffee Shop has to compute for the sales budget of the operation from the January to March 2019. The shop offers flavored coffee: cappuccino, mocha, latte and brewed coffee which are sold at P75.00, P72.00, P80.00 and P60.00 per serving (in cups) respectively. The following data shows anticipated volume of sales (in cups) during the first quarter. Item January March February Cappuccino 150 200 195 100 120 90 80 110 115 175 150 180 Mocha Latte Brewed Act Go Prepare the monthly schedule of production budget of Mary's Coffee Shop. The inventory of the shop is estimated as follows. Item Ending Inventory (units) Cappuccino Mocha Latte Brewed Ending and beginning inventory are expected to increase by 2% and 1% for the month of February and March respectively. Use table to show your answer. 50 25 15 40 Beginning Inventory (units) Item Units to be sold Add: Desired ending inventory Total Less: Beginning inventory Units to be produced Compute the production budget for the month of January to March. January M А ABCD 60 50 с 25 50 February N E F G H March O I J K L

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter9: Profit Planning And Flexible Budgets

Section: Chapter Questions

Problem 45BEB: Pilsner Inc. purchases raw materials on account for use in production. The direct materials...

See similar textbooks

Similar questions

Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
Q. Prepare a revenues budget for the year, assuming that Ever Clean charges customers $0.60 per square foot.
Pearl Products Limited of Shenzhen, China, manufactures and distributes toys throughout South East Asia. Three cubic centimeters (cc) of solvent H300 are required to manufacture each unit of Supermix, one of the company's products. The company is planning its raw materials needs for the third quarter, the quarter in which peak sales of Supermix occur. To keep production and sales moving smoothly, the company has the following inventory requirements: a. The finished goods inventory on hand at the end of each month must equal 3,000 units of Supermix plus 25% of the next month's sales. The finished goods inventory on June 30 is budgeted to be 13,250 units. b. The raw materials inventory on hand at the end of each month must equal one-half of the following month's production needs for raw materials. The raw materials inventory on June 30 is budgeted to be 63,375 cc of solvent H300. c. The company maintains no work in process inventories. A monthly sales budget for Supermix for the third…
Styles Abuhatim LLC has given the following particulars. You are required to prepare a cash budget for the three months ending 31st December 2019 Months Sales Materials Wages ( OMR) Over heads (OMR) (OMR) (OMR) August September October 20000 10200 3800 1900 21000 10000 3800 2100 23000 9800 4000 2300 November 25000 10000 4200 2400 December 30000 10800 4500 2500 Credit terms are 1.. Sales /Debtors 10% sales are on Cash, 50% of the credit sales are collected in next month and the balance in the following month 2. Creditors- materials 2 months Wages 1 month -1 month Overheads 3. Cash balance on 1st October is expected to be Ro.8000 4. A machinery will be installed in August at a cost of RO.100000, the monthly instalment of RO.5000 is payable from October onwards 5. Dividend at 10% on preference share capital RO.300,000 will be paid on 1* December 2019 6. Advance to be received for the sale of vehicles RO.20000in December 7. Income tax to be received in December RO.5000
On January 1, 2022, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2022. Sales units: Ending raw materials inventory: Ending finished goods inventory: Third-quarter production: First quarter 5,000; second quarter 6,000; third quarter 7,000. 40% of the next quarter's production requirements. 25% of the next quarter's expected sales units. 7,200 units. The ending raw materials and finished goods inventories at December 31, 2021, follow the same percentage relationships to production and sales that occur in 2022. Three pounds of raw materials are required to make each unit of finished goods. Raw materials purchased are expected to cost $4 per pound.
1.2 REQUIRED Use the information provided below to prepare the Direct Materials Purchases Budget for April 2019. INFORMATION The estimated sales volumes of Product Jip of Polo Manufacturers for April and May 2019 are as follows: Units April 18 000 May 15 000 The policy of Polo Manufacturers is to maintain a finished goods closing inventory each month at a level equal to 40% of the next month's budgeted sales. Each unit of Product Jip requires 2 kg of Material A and 1 kg of Material B. The costs per kg of Material A and Material B are R10 and R20 respectively. Inventories of materials are expected to be as follows: Material A Material B Opening inventory 5 000 kg 6 000 kg Closing inventory 1 000 kg 2 000 kg
Perez Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Perez expects sales in January year 1 to total $210,000 and to increase 20 percent per month in February and March. All sales are on account. Perez expects to collect 68 percent of accounts receivable in the month of sale, 24 percent in the month following the sale, and 8 percent in the second month following the sale. Required Prepare a sales budget for the first quarter of year 1. Determine the amount of sales revenue Perez will report on the year 1 first quarterly pro forma income statement. Prepare a cash receipts schedule for the first quarter of year 1. Determine the amount of accounts receivable as of March 31, year 1. Complete this question by entering your answers in the tabs below. Prepare a sales budget for the first quarter of year 1.
Q.No. 2 Abuhatim LLC has given the following particulars. You are required to prepare a cash budget for the three months ending 31st December 2019 Months Sales Materials Wages Over heads (OMR) (OMR) (OMR) (OMR) 1900 August 20000 10200 3800 September 21000 10000 3800 2100 October 23000 9800 4000 2300 November 25000 10000 4200 2400 December 30000 10800 4500 2500 Credit terms are 1. Sales /Debtors 10% sales are on Cash , 50% of the credit sales are collected in next month and the balance in the following month 2. Creditors – materials 2 months Wages 1 month Over heads – 1 month 3. Cash balance on 1st October is expected to be Ro.8000 4. A machinery will be installed in August at a cost of RO.100000, the monthly instalment of RO.5000 is payable from October onwards 5. Dividend at 10% on preference share capital RO.300,000 will be paid on 1st December 2019 6. Advance to be received for the sale of vehicles RO.20000in December 7. Income tax tobe received in December RO.5000
G & J Merchandising & More is a family-owned auto-parts store. You are the managementaccountant of the concern and have been given the task of preparing the cash budget for thebusiness for the quarter ending March 31, 2021. Your data collection has yielded the following: (i) Extracts from the sales and purchases budgets are as follows: Month Novemer 2020- March 2021 Cash Sales Sales on Account Purchases November $151,100 $480,000 $390,000 December $145,500 $600,000 $360,000 January $159,025 $700,000 $505,000 February $169,350 $650,000 $400,000 March $176,200 $800,000 $518,000 (ii) An analysis of the records shows that trade receivables (accounts receivable) are settledaccording to the following credit pattern, in accordance with the credit terms 2/30, n90:45% in the month of sale30% in the first month following the sale25% in the second month following the sale (iii) Expected purchases include cash purchases of $25,000 in January and $18,000 in March.All…
From the attached photo answer the following: 1. What is the sales collection schedule for the six (6) months showing the accounts receivable at the end of the six months ending June 2021.2.What is he purchase payment schedule for the six (6) months showing discounts received and accounts payable at the end of the six months ending June 2021.3. What is the cash budget including a total column for the three (3) months ending June 2021 (April to June 2021).
G & J Merchandising & More is a family-owned auto-parts store. You are the managementaccountant of the concern and have been given the task of preparing the cash budget for thebusiness for the quarter ending March 31, 2021. Your data collection has yielded the following: (i) Extracts from the sales and purchases budgets are as follows: Month Novemer 2020- March 2021 Cash Sales Sales on Account Purchases November $151,100 $480,000 $390,000 December $145,500 $600,000 $360,000 January $159,025 $700,000 $505,000 February $169,350 $650,000 $400,000 March $176,200 $800,000 $518,000 (ii) An analysis of the records shows that trade receivables (accounts receivable) are settledaccording to the following credit pattern, in accordance with the credit terms 2/30, n90:45% in the month of sale30% in the first month following the sale25% in the second month following the sale (iii) Expected purchases include cash purchases of $25,000 in January and $18,000 in March.All…
Prepare a sales budget. Palermo Company estimates that unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 15,000 in quarter 3; and 18,000 in quarter 4. Using a sales price of $70 per unit, prepare the sales budget by quarters for the year ending December 31, 2019. Palermo Company Sales Budget For the Year Ending December 31, 2019 Description Q1 Q2 Q3 Q4 Year Estimates sales Sales price x unit Sales Revenue 2. Prepare a production budget for 2 quarters. Sales budget data for Palermo Company are given in exercise 1. Management desires to have an ending finished goods inventory equal to 25% of the next quarter's expected unit sales. Prepare a production budget by quarters for the first 6 months of 2019. Palermo Company Direct Labor Budget For the Six Months Ending June 30, 2019…