Obunga is a new startup by fresh graduates from UCLA who home deliver Pasta across LA. They make Pastas using imported pastas, cheese and locally produced chicken along with all the other fresh ingredients of finest quality. They have two Pastas: the standard Pasta Italiano and the customized one named Pasta Basta. The standard Pastas are prepared with antibiotic free chicken along with other ingredients and the customized Pastas add number of options that are customized as per customer demand and are Oven baked. For the third quarter of 2021, estimated sales in units for each product line are as follows:

The CEO of the Obunga provided you with the following additional information:

Sales: The actual sales for May and the forecasted sales for June were Tk. 1,120,000 and Tk. 1,050,000 respectively for the standard pasta. The relevant numbers for the customized pasta are Tk. 650,000 in May and Tk. 500,000 in June. Obunga prices the standard pasta at Tk. 250 per container and Tk. 400 per container for the customized pasta.

Inventory Policy: The Company believes in customer satisfaction and therefore doesnt store any ready products. Rather theyre using a lean production process where theyre producing on demand.

Production requirements: The standard Pastas require 150 gm of chicken per plate and the customized ones require 250 gm of chicken. Chicken costs Tk. 280 per Kg. The cost of all other material (i.e.: pasta, cheese, pasta sauce, capsicum, salt etc.) is Tk. 70 per container for standard units and Tk.100 for the customized units. The standard pasta requires 15 minutes of direct labor time per container and the customized ones require 25 minutes of direct labor time. Direct labor cost per hour is Tk. 150. Fixed Manufacturing Overhead is expected to be Tk. 40,000 per month, of which Tk. 14,000 for non-cash depreciation. Obunga applies manufacturing overhead to units based on direct labor hours and the variable manufacturing overhead rate is Tk. 25 per direct labor hours.

Inventory policy-raw materials: Chicken is the main ingredient of Pastas. With regard to the chicken used in production, Obunga likes to keep safety stock of 30% of its need of chicken for the next months anticipated production. Obunga ended June, 2021 with 155 Kg of meat in stock.

Payables Policy: Obungai signed an MOU with Bengal Meat where Bengal Meat agrees to supply all the meat needs on credit. According to the credit policy of Bengal meat for Obunga, 40% of the monthly purchase is due on the month of purchase and the rest of the due is settled in following month of purchase. Accounts payable for materials and other items were expected to be Tk. 150,000 on June 31, 2021. Costs of all other materials are purchased on a cash basis during the month of purchase according to the monthly production need.

Collection policy: Half of sales of each month is on cash to regular customers, rest half is to corporate offices. Obunga delivers their products to corporate offices offering credit term. For both the standard and customized pasta sold on credit to corporate offices, 20 percent of sales are collected in the month of sales, 70 percent of credit sales are collected the following month and the rest of the dues are collected in the second month following the month of sales.

Sales and Administration costs: Monthly marketing and administrative expenses consist of the following: Salaries and wages: Tk. 15,000, Advertising and promotions Tk. 20,000, Rent: Tk. 40,000 Utilities: 4% of revenue.

Cash and financing: Obunga expects to maintain a minimum cash balance of Tk. 150,000 per month. Borrowing can make up any anticipated cash shortage at 10% annual interest. Bank will only lend (and accept repayments) in Tk. 1,000 increments. Cash balance to start the quarter is Tk. 180,000.

Other information: Obunga will make a payment of Tk. 230,000 during August for equipment purchased on credit on June. The company also plans to pay dividends of Tk. 120,000 in July.

Required: Prepare the following budgets for Obunga for the third quarter ending September 2021. Also, show the breakdown of the quarterly budgets into monthly.

Month Pasta Italiano (in containers) Pasta Basta (in containers) July 850 300 August 1,000 550 September 930 620 October 1,560 500 November 1,350 440 Pasta Italiano Price Total Sale of Pasta Italiano Sales Budget July August 850 1,000 250 250 2,12,500 2,50,000 September 930 250 2,32,500 Quarter 2,780 250 6,95,000 Pasta Basta Price Total Sale of Pasta Basta 300 400 1,20,000 550 400 2,20,000 620 400 2,48,000 1,470 400 5,88,000 Total Sale 3,32,500 4,70,000 4,80,500 12,83,000 Production Budget July August 850 1,000 September 930 Quarter 2,780 Pasta Italiano 1,470 Pasta Basta 300 550 620 Production is same as sales as Obunga doesn't maintain any finished goods inventory Raw materials budget July August September Quarter 930 Required production Pasta Italiano Chicken per plate (kg) Total 850 0.15 127.50 1,000 0.15 150.00 0.15 139.50 2,780 0.15 417.00 Pasta Basta Chicken per plate (kg) Total 300 0.25 75.00 550 0.25 137.50 620 0.25 155.00 1,470 0.25 367.50 202.50 86.25 Raw materials required Add Desired ending inventory of raw materials (kg) Total needs (ounces) Less beginning inventory of raw materials (ounces) Raw aterials to be purchased Cost of chicken per kg Cost of chicken to be purchased (A) 288.75 -155.00 133.75 280.00 37,450.00 287.50 294.50 88.35 235.35 375.85 529.85 -86.25 -88.35 289.60 441.50 280.00 280.00 81,088.00 1,23,620.00 784.50 235.35 1,019.85 -155.00 864.85 280.00 2,42,158.00 Pasta Italiano Other materials Total (B) 850.00 70.00 59,500.00 1,000.00 70.00 70,000.00 930.00 70.00 65,100.00 2,780.00 70.00 1,94,600.00 Pasta Basta Other materials Total (C) 300.00 100.00 30,000.00 550.00 100.00 55,000.00 620.00 100.00 62,000.00 1,470.00 100.00 1,47,000.00 Total Raw materials A+B+C 1,26,950.00 2,06,088.00 2,50,720.00 5,83,758.00 Direct Labour budget July August September Quarter 850 930 Required production Pasta Italiano Labour per container (min) Total (hrs) (A) 15.00 212.50 1,000 15.00 250.00 15.00 232.50 2,780 15.00 695.00 300 550 620 Pasta Basta Labour per container (hrs) Total (hrs) (B) 25.00 125.00 25.00 229.17 25.00 258.33 1,470 25.00 612.50 Total hours required C = (A) + (B) 337.50 479.17 490.83 1,307.50 Direct labour rate per hour (D) 150.00 150.00 150.00 150.00 Total Direct labour cost C*D 50,625.00 71,875.00 73,625.00 1,96,125.00 Prepare the following schedules: i. Expected cash collections ii. Expected cash disbursements for materials