Ewuarbena & Co Manufacturing Ltd have budgeted to sell these quantities of its products, Chocomix, for the coming months in 2020: January – 160,000 sachets; February – 240,000 sachets; March – 200,000 sachets; April – 400,000 sachets; and May – 150,000 sachets. The company expects to sell each sachet for GHS20. The company has decided that to avoid losing customers arising from production hold-ups it would like to maintain a finished goods inventory in the future equal to one-fifth of the following month's budgeted sales. At the beginning of January 2020, the company had finished goods inventory of 10,000 sachets.

Ewuarbena & Co Manufacturing Ltd have budgeted to sell these quantities of its products, Chocomix, for the coming months in 2020: January – 160,000 sachets; February – 240,000 sachets; March – 200,000 sachets; April – 400,000 sachets; and May – 150,000 sachets. The company expects to sell each sachet for GHS20. The company has decided that to avoid losing customers arising from production hold-ups it would like to maintain a finished goods inventory in the future equal to one-fifth of the following month's budgeted sales. At the beginning of January 2020, the company had finished goods inventory of 10,000 sachets.

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter7: The Master Budget And Flexible Budgeting

Section: Chapter Questions

Problem 10Q: If the sales forecast estimates that 50,000 units of product will be sold during the following year,...

See similar textbooks

Similar questions

Obaapa Fashions Ltd has budgeted to sell 100,000 pieces of face masks for April 2020. At the end of March 2020, the company had 20,000 pieces of face mask in inventory and would like to have an inventory of 30,000 pieces of face masks at the end of April. Each piece of face mask requires 2 square meters of treated fabric, the primary raw material. Inventory of the treated fabric at the beginning of April is 5,000 square meters. It is expected that each square meter of the treated fabric will cost GHS3. Assuming the sales budget is met, and the desired ending inventory of the face mask is achieved, how many square meters of the treated fabric need to be purchased in April 2020, in order to have an ending inventory of 8,000 square meters of the treated fabric? What will be the cost of purchases for April 2020? (show all workings clearly).
If you have the following data for the purpose of preparing the cash budget for Al-Iman Company for the year 2022, which has a capital:- 1) Expected monthly sales in 2022: June 100000, July 80000, August 60000, September 100000, October 80000. 2) The expected cash sales are 10%, and the forward sales are obtained on the basis of 50% in the month following the sale, 20% in the month following the sale, 30% in the third month, and a bad debt probability of 15% 3) The Gross Profit Ratio is 40% 4) The company will purchase monthly raw materials on the basis of the sales of the following month, and the purchase price will be paid in the month following the purchase. 5) The fixed expenses amount to 36000 riyals distributed equally over the months of the year 6) The monthly consumption is estimated at 2000 riyals 7) Variable payments amount to 10% of the sales value, 50% of which is paid in the same month, and the rest in the immediately following month. 8) The company will purchase a new…
CXZ Corporation expects to sell 150,000 units during the first quarter of 2021, with an ending inventory for the quarter of 20,000 units. Variable manufacturing costs are budgeted at P50 per unit, with 60% of total variable manufacturing costs requiring cash payments during the quarter. Fixed manufacturing costs are budgeted at P120,000 per quarter, 45% of which are expected to require cash payment during the quarter. 1. In the cash budget, payments for manufacturing costs during the quarter will total?
The Financial Manager of the Grand Dubai Hotel has prepared the following flexed budget for 2024. The Grand Dubai is a large hotel, which can provide up to a maximum of 44,000 guest nights per year. Due to the recent excessively hot weather, the Sales Manager has suggested that 30,000 guests is a more realistic target for 2024. Based on this, what are the expected total costs for 2024?
Elliott Industries, a wholesale company, is considering whether to open a new distribution center. The center would open January 1, 2021. To make the decision, the planning committee requires a master budget for the center’s first quarter of operation (January, February, and March of 2022). Required You are to construct the first quarter master budget based on the following expectations: January sales are estimated to be $400,000 of which $100,000 will be cash sales and $300,000 will be on credit. The company expects sales to grow 10% per month for the first few months of operation. Prepare a sales budget for the first quarter. The company expects to collect 100% of accounts receivable in the month following the sale. Prepare a schedule of expected cash receipts for the first quarter. Cost of goods sold will be 60% of sales. Company policy is to budget an ending inventory balance equal to 25% of the next month’s projected cost of goods sold. Assume Elliott expects April…
the exercise. If you have the following data for the purpose of preparing the cash budget for Al-Iman Company for the year 2022, which has a capital: 1- Expected monthly sales in 2022: June 100000, July 80000, August 60000, September 100,000, October 80,000. 2- The cash sales are expected to be 10%, and the forward sales are to be made on the basis of 50% in the following month For sale, 20% in the following month, 30% in the third month, and there is a possibility of bad debts at a rate of %15 3- The percentage of gross profit is 40%. 4- The company will purchase monthly raw materials based on the sales of the following month, and the value of. will be paid Purchases in the month following the purchase. 5- The fixed expenses amount to 36000 riyals distributed equally over the months of the year. 6- The monthly consumption is estimated at 2000 riyals. 7- Variable payments are 10% of the sales value, 50% of which is paid in the same month, and the rest in Immediately next month. 8- The…
Jarziz Company is in the period of budgeting for 2022. The Sales manager forecasted the number of units to be sold as 25000 units and determined the selling price as 40 OMR per unit. The management revised these estimates with a 20 % increase in selling price and with a 25 % decrease in the number of units sold. According to these estimates, which of the following is revised Sales (OMR)? Select one: a. 1,150,000 b. 1,010,000 c. 900,000 d. 980,000
Jarziz Company is in the period of budgeting for 2022. The Sales manager forecasted the number of units to be sold as 25000 units and determined the selling price as 40 OMR per unit. The management revised these estimates with a 20 % increase in selling price and with a 25 % decrease in the number of units sold. According to these estimates, which of the following is revised Sales (OMR)? Select one: a. 1,150,000 b. 1,010,000 c. 980,000 d. 900,000 Clear my choice 2) Some selected financial statement items belonging to MNO Company are given in the table below. According to this information, which of the following is Return on Assets (ROA)? Inventory 12,500 Current Assets 50,000 Current Liabilities 40,000 Non-current Assets 90,000 Net Profit 12,000 Shareholders' Equity 65,000 Select one: a. 12.2% b. 18.5% c. 9.23% d. 13.3%
⦁ MNO Company has projected to sell 500,000 units of its primary product in 2022. It estimates the selling price to be $50 per unit. Required: ⦁ If MNO Company Estimates the unit cost to produce the 500,000 units consists of Material cost $5; Direct labor cost $7; and manufacturing overhead $8. What is the total production cost for the its annual projected sales unit? Show Computation in a production budget format.
On January 1, 2020, the Hassan Engineering Co has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 5,000; second quarter 6,000; third quarter 7,000 Ending finished goods inventory: 30% of the next quarter’s expected sales units The ending finished goods inventories at December 31, 2019, follow the same percentage relationships to production and sales that occur in 2020. What is the budgeted production for Quarter 2?
Corona2020, a merchandising firm, needs to prepare budgets for July 2020. The followings arethe data regarding the company’s plans for 2020.1. The actual and forecasted sales (in units) of the company are as follows:June 55,000 July 70,000 August 75,000The unit-selling price is estimated at RM14.50. All sales are on account; 60% of themonthly sales is expected to be collected in the month of sales, and another 40% will bereceived in the following month after the sales.2. The company’s policy indicates that the ending inventory of merchandises should be equalto 15% of the current month’s sales plus 5% of the following month’s sales.3. The cost of goods sold is about 65% of the total monthly sales.4. The company pays 60% of the purchase in cash, and the balance is paid in the followingmonth after the purchases. Total cost of merchandises purchased in June was RM594,500.5. In July 2020, the company expects to purchase a piece of commercial land costingRM80,000.6. Monthly administrative…
Roberts and Company has a budgeted sales commissions of $200,000 for 2020, based on sales estimates of $300,000 for the same year. After the first quarter however, they realize that sales are exceeding expectations. Sales are now expected to reach $400,000 for 2020. By how much will Roberts and Company adjust their budget beginning in the 2nd quarter for sales commissions? Roberts and Company uses a static budgeting process.