Problem Set 2. Production Budget 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 February March January Cappuccino 150 200 195 100 120 90 115 180 Mocha Latte Brewed 80 175 24. Answer to cell M. 25. Answer to cell A. 26. Answer to cell B. 27. Answer to cell C. 28. Answer to cell D. 29. Answer to cell N. 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. 110 150 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 Beginning Inventory (units) 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 Compute the production budget for the month of January to March. Item Units to be sold Add: Desired ending inventory Total Less: Beginning inventory Units to be produced 60 50 25 50 January M A B C February N E F G H March O I J K
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Step by step
Solved in 2 steps