Established in 2022, Lady N is considered as one of the finest patisseries in Hong Kong. Lady N prides itself in creating the freshest and finest cakes that are handmade by its dedicated pastry chefs with the finest ingredients. The marketing department of Lady N has submitted the following forecasts for the upcoming months: May June July August September Budgeted sales (units) 12,000 24,000 40,000 20,000 60,000 Budgeted production (units) 13,000 26,000 50,000 25,000 60,000 Additional information is as follows: 1. Direct materials are mainly premium cake our, unsalted butter, and fresh eggs. The information for the purchases of these materials is given below. The payment is made in the month following the purchases. June July August September 3 $ $ 5 Premium cake our 90,000 150,000 125,000 260,000 Unsalted butter 10,000 18,000 15,000 19,000 Fresh eggs 4,800 10,000 5,500 1,200 The average selling price per cake is $78. All sales are on credit. Based on past experience, Lady N projects that 30% of invoices are paid in the month of sale, 50% are paid in the month following the sale, and another 15% are paid two months following the sale. The remaining 5% will be uncolleciible. Each cake needs 0.25 direct labor hour and each direct labor hour costs $40. Labor costs are paid in the month incurred. Lady N also incurs fixed manufacturing overhead costs of $850,000 per month {including $100,000 for depreciation ofthe baking equipment). The cost is paid in the month incurred. Lady N purchased an automatic dough mixer for $300,000 and a baking oven for $500,000 in August and September with cash respectively. The depreciation of this equipment has been included in the fixed manufacturing cost mentioned in [4]. The beginning cash balance for 1 July is $800,000 and Lady N wants to maintain a cash balance not less than this level at the end of each month. Lady N has an agreement with a local bank that allows Lady N to borrow in increments of$10,000 at the beginning of each month, up to a total loan balance of $2,000,000. The simple interest rate on these loans is 12% p.a. The company would like to pay back the borrowings as soon as it can. No partial payback is allowed. Any payment is made at the end of the month. A tax bill of $700,000 is to be paid in July