Delaware Chemical Company uses oil to produce two types of plastic products, P1 and P2. Delaware budgeted 30,500 barrels of oil for purchase in June for $75 per barrel. Direct labor budgeted in the chemical process was $274,500 for June. Factory overhead was budgeted at $411,800 during June. The inventories on June 1 were estimated to be: Oil $19,200
P1 12,900
P2 11,000
Work in process 15,900
The desired inventories on June 30 were:

Oil $21,100
P1 11,800
P2 10,400
Work in process 16,500

Required:
Use the preceding information to prepare a cost of goods sold budget for June.

Variable rate cd’s = $90 treasury bills = $150 discount loans = $20 treasury notes = $100 fixed rate cds = $160 money market deposit accts. = $140 savings deposits = $90 fed funds borrowing = $40 variable rate mortgage loans $140 demand deposits = $40 primary reserves = $50 fixed rate loans = $210 fed funds lending = $50 equity capital = $120 a. develop a balance sheet from the above data. be sure to divide your balance sheet into rate-sensitive assets and liabilities as we did in class and in the examples. b. perform a standard gap analysis and a duration analysis using the above data if you have a 1.15% decrease in interest rates and an average duration of assets of 5.4 years and an average duration of liabilities of 3.8 years. c. indicate if this bank will remain solvent after the valuation changes. if so, indicate the new level of equity capital after the valuation changes. if not, indicate the amount of the shortage in equity capital.