Globex Investment Capital Corporation owns six companies that have the following estimated returns ($ million) if sold in one of the next three years (from Taylor III, 2004). To generate operating funds, the company must sell at least $20 million worth of assets in year 1, $25 million in year 2, and $35 million in year 3. Globex wants to develop a plan for selling these companies during the next three years that will maximize return. Formulate an integer programming model for this problem and use Excel Solver to solve it.Globex Investment Capital Corporation owns six companies that have the following estimated returns ($ million) if sold in one of the next three years (from Taylor III, 2004). To generate operating funds, the company must sell at least $20 million worth of assets in year 1, $25 million in year 2, and $35 million in year 3. Globex wants to develop a plan for selling these companies during the next three years that will maximize return. Formulate an integer programming model for this problem and use Excel Solver to solve it.Globex Investment Capital Corporation owns six companies that have the following estimated returns ($ million) if sold in one of the next three years (from Taylor III, 2004). To generate operating funds, the company must sell at least $20 million worth of assets in year 1, $25 million in year 2, and $35 million in year 3. Globex wants to develop a plan for selling these companies during the next three years that will maximize return. Formulate an integer programming model for this problem and use Excel Solver to solve it.Globex Investment Capital Corporation owns six companies that have the following estimated returns ($ million) if sold in one of the next three years (from Taylor III, 2004). To generate operating funds, the company must sell at least $20 million worth of assets in year 1, $25 million in year 2, and $35 million in year 3. Globex wants to develop a plan for selling these companies during the next three years that will maximize return. Formulate an integer programming model for this problem and use Excel Solver to solve it.Globex Investment Capital Corporation owns six companies that have the following estimated returns ($ million) if sold in one of the next three years (from Taylor III, 2004). To generate operating funds, the company must sell at least $20 million worth of assets in year 1, $25 million in year 2, and $35 million in year 3. Globex wants to develop a plan for selling these companies during the next three years that will maximize return. Formulate an integer programming model for this problem and use Excel Solver to solve it.Globex Investment Capital Corporation owns six companies that have the following estimated returns ($ million) if sold in one of the next three years (from Taylor III, 2004). To generate operating funds, the company must sell at least $20 million worth of assets in year 1, $25 million in year 2, and $35 million in year 3. Globex wants to develop a plan for selling these companies during the next three years that will maximize return. Formulate an integer programming model for this problem and use Excel Solver to solve it.
1] Prepare journal entries for the transactions, adjustments and closing entries necessary to complete the statements. 2] Prepare the financial statements [Income statement and Balance Sheet] for Cassia Company for year B A
i
i Year B:
5 A company reported the following beginning balances:
.5 Cash 10000
.7 MB 13000
.8 allowance for doubt acct —5000
,9 Equipment 24000
[0 less accumulated depreciation 72400
‘J. Prepaid insurance 4000
‘_2 Patent [4—year remaining life) 5600
‘3 Total assets 49200
[4
‘5 Accounts payable 12000
[6 Unearned revenue 9000
[7 Common stock 5000 shares
13 with a Par value of $2 10000
[9 Additional paid—in—capital 7000
:0 Retained earnings 11200
Total liabilities and SHE 49200 l??lwlml?il?lwlm F’- Assume all accounts have normal balances. During Year B the following events occurred Cassia performed services on account Cassia collected cash from customers Cassie reported operating expenses paid in cash Cassie estimates bad debt expense at 3% of credit sales. Other events during the year include: 1/1/YR B
1/1/ Yr B I’ll/Year B UlfYR B 10/1[Year B
llllerar B
12/31fYR B Cassia wrote ol‘F accounts receivable as uncollectible Cassia entered into a 5—year noncancellable lease The lease requires annual payments on 1/1 each year. The equipment had a cash price of $45,000 and the company
calculated payments based on 12% expected returns. Further, Cassia depreciates leased assets using straight—line
depreciation. Hint: Find the payment and the amortization table.
Cassia issued ten $1000 bonds in exchange for cash. The bonds are issued at par and pay interest on 12/31 and 5/31. The bonds mature in 5 years. Stated rate 5%. Market rate 8%
Cassia purchased a additional equipment Cassia paid cash for the equipment. Cassia purchase $3000 in stock, holding the stock as a trading investment.
Cassia repurchased 1000 shares of common stock for treasury. Cassia sold equipment with an original cost of $5000 and a book value of $4000 for $6400 cash 140,000
72,000
23000 3700 $2 2,000
i
i Year B:
5 A company reported the following beginning balances:
.5 Cash 10000
.7 MB 13000
.8 allowance for doubt acct —5000
,9 Equipment 24000
[0 less accumulated depreciation 72400
‘J. Prepaid insurance 4000
‘_2 Patent [4—year remaining life) 5600
‘3 Total assets 49200
[4
‘5 Accounts payable 12000
[6 Unearned revenue 9000
[7 Common stock 5000 shares
13 with a Par value of $2 10000
[9 Additional paid—in—capital 7000
:0 Retained earnings 11200
Total liabilities and SHE 49200 l??lwlml?il?lwlm F’- Assume all accounts have normal balances. During Year B the following events occurred Cassia performed services on account Cassia collected cash from customers Cassie reported operating expenses paid in cash Cassie estimates bad debt expense at 3% of credit sales. Other events during the year include: 1/1/YR B
1/1/ Yr B I’ll/Year B UlfYR B 10/1[Year B
llllerar B
12/31fYR B Cassia wrote ol‘F accounts receivable as uncollectible Cassia entered into a 5—year noncancellable lease The lease requires annual payments on 1/1 each year. The equipment had a cash price of $45,000 and the company
calculated payments based on 12% expected returns. Further, Cassia depreciates leased assets using straight—line
depreciation. Hint: Find the payment and the amortization table.
Cassia issued ten $1000 bonds in exchange for cash. The bonds are issued at par and pay interest on 12/31 and 5/31. The bonds mature in 5 years. Stated rate 5%. Market rate 8%
Cassia purchased a additional equipment Cassia paid cash for the equipment. Cassia purchase $3000 in stock, holding the stock as a trading investment.
Cassia repurchased 1000 shares of common stock for treasury. Cassia sold equipment with an original cost of $5000 and a book value of $4000 for $6400 cash 140,000
72,000
23000 3700 $2 2,000
