The Distribution Center of 123 Oil and Gas Company wants a master budget for the next...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Distribution Center of 123 Oil and Gas Company wants a master budget for the next three months, beginning January Ist. It desires an ending minimum cash balance of $4,000 each month. Sales are forecasted at an average selling price/transfer price of $40 per widget. In January, the Distribution Centre is beginning just-in-time deliveries from suppliers, which means that purchases equal expected sales. The December 31 inventory balance will be drawn down to $5,000, which will be the desired ending inventory thereafter. Purchase price per widget is $20. Purchases during any given month are paid in full during the following month. All sales are on credit, payable within thirty days, but experience has shown that 60 percent of current sales are collected in the current month, 30 percent in the next month, and 10 percent in the month thereafter. Bad debts are negligible. The Distribution Centre sells to related sister corporations as well as outside/extermal sales. The following are some of the expenses for the Distribution Centre: Wages and salaries Insurance expired Depreciation S12,000/month 100/month 200/month Miscellaneous 2,000/month 200/month + 10% of quarterly sales over $10,000 Rent Cash dividends of S1,000 are to be paid quarterly, beginning January 15, and are declared on the fifteenth of the previous month. All operating expenses are paid as incurred, except insurance, depreciation, and rent. Rent of $200 is paid at the beginning of each month and the additional 10 percent of sales is paid quarterly on the tenth of the month following the quarter. The next settlement is due January 10. The company plans to buy some new office fumiture for $2,000 cash-on-delivery in March. To the distribution company this will be considered a capital purchase. Money can be borrowed and repaid in multiples of $500, at an interest rate of 12 percent per annum. Management wants to minimize borrowing and repay rapidly. Interest is computed and paid when the principal is repaid. Assume that borrowing takes place at the beginning, and repayment at the end, of the months in question. Money is never borrowed at the beginning and repaid at the end of the same month. Compute interest to the nearest dollar. ASSETS AS OF LIABILITIES AS OF DECEMBER 31, Cash Accounts receivable Inventory Prepaid insurance Fixed assets, net DECEMBER 31, $4,000 16,000 31,250 1,200 10,000 $62.450 Accounts payable (merchandise) Dividends payable Rent payable S28,750 1,000 6,000 S35.750 *November 30 inventory balance = S12,500 Recent and forecasted sales: October $30,000 December $20,000 February $60,000 April $36,000 $50,000 March November $20,000 January $30,000 Compute borrowing at the beginning of the period and repayment at the end of the period for months January, February and March The Distribution Center of 123 Oil and Gas Company wants a master budget for the next three months, beginning January Ist. It desires an ending minimum cash balance of $4,000 each month. Sales are forecasted at an average selling price/transfer price of $40 per widget. In January, the Distribution Centre is beginning just-in-time deliveries from suppliers, which means that purchases equal expected sales. The December 31 inventory balance will be drawn down to $5,000, which will be the desired ending inventory thereafter. Purchase price per widget is $20. Purchases during any given month are paid in full during the following month. All sales are on credit, payable within thirty days, but experience has shown that 60 percent of current sales are collected in the current month, 30 percent in the next month, and 10 percent in the month thereafter. Bad debts are negligible. The Distribution Centre sells to related sister corporations as well as outside/extermal sales. The following are some of the expenses for the Distribution Centre: Wages and salaries Insurance expired Depreciation S12,000/month 100/month 200/month Miscellaneous 2,000/month 200/month + 10% of quarterly sales over $10,000 Rent Cash dividends of S1,000 are to be paid quarterly, beginning January 15, and are declared on the fifteenth of the previous month. All operating expenses are paid as incurred, except insurance, depreciation, and rent. Rent of $200 is paid at the beginning of each month and the additional 10 percent of sales is paid quarterly on the tenth of the month following the quarter. The next settlement is due January 10. The company plans to buy some new office fumiture for $2,000 cash-on-delivery in March. To the distribution company this will be considered a capital purchase. Money can be borrowed and repaid in multiples of $500, at an interest rate of 12 percent per annum. Management wants to minimize borrowing and repay rapidly. Interest is computed and paid when the principal is repaid. Assume that borrowing takes place at the beginning, and repayment at the end, of the months in question. Money is never borrowed at the beginning and repaid at the end of the same month. Compute interest to the nearest dollar. ASSETS AS OF LIABILITIES AS OF DECEMBER 31, Cash Accounts receivable Inventory Prepaid insurance Fixed assets, net DECEMBER 31, $4,000 16,000 31,250 1,200 10,000 $62.450 Accounts payable (merchandise) Dividends payable Rent payable S28,750 1,000 6,000 S35.750 *November 30 inventory balance = S12,500 Recent and forecasted sales: October $30,000 December $20,000 February $60,000 April $36,000 $50,000 March November $20,000 January $30,000 Compute borrowing at the beginning of the period and repayment at the end of the period for months January, February and March
Expert Answer:
Answer rating: 100% (QA)
CASH BUDGET JANUARY FEBRUARY MARCH OPENING BALANCE 400000 ... View the full answer
Related Book For
Cost Accounting Foundations and Evolutions
ISBN: 978-1111626822
8th Edition
Authors: Michael R. Kinney, Cecily A. Raiborn
Posted Date:
Students also viewed these accounting questions
-
The value of an oil and gas company is tied to two fundamental facts. The first is the amount of oil and gas the company is presently producing. This amount, along with unit prices, determines the...
-
Phillips Petroleum is an integrated oil and gas company with headquarters in Bartlesville, Oklahoma, where it was founded in 1917. The company engages in petroleum exploration and production...
-
Barnes Entertainment Corporation prepared a master budget for the month of November that was based on sales of 150,000 board games. The budgeted income statement for the period is as follows. During...
-
Selling price Variable costs: Direct materials Direct labour Variable manufacturing overhead Total variable cost Contribution margin Contribution margin ratio Contribution margin per labour hour O...
-
A sample of 20 items from manufacturer A were measured and a sample mean of 2376.3 and a sample standard deviation of 24.1 were obtained. Also, a sample of 24 items from manufacturer B were measured...
-
Identify your present/past boss's life position, and use of stroking.
-
Consider two alternatives, each of which will accomplish the same EPA-mandated pollution control. Using an incremental IRR analysis, determine the preferred alternative assuming MARR is 20...
-
Calla Company produces skateboards that sell for $50 per unit. The company currently has the capacity to produce 90,000 skateboards per year, but is selling 80,000 skateboards per year. Annual costs...
-
1. Why have neo-classical economists generally argued that international economic relations are not zero-sum in character? What theoretical frameworks have they used to support this argument? It's...
-
1. Set up an expanded accounting equation spreadsheet using the following accounts: Assets Liabilities Owner's Equity Cash Accounts Payable I freedman, Capital Supplies L freedman, Withdawals...
-
A walkway surrounds a rectangular garden. The width of the garden is 8 feet, and the length is 6 feet. The width x of the walkway around the garden is the same on every side. Write an expression that...
-
(b) Describe what components a system dynamics model consists of. Figure Q1b shows the information feedback in a system. What should be the sign (+ or -), in terms of the relationship between 'human...
-
a) Write the output when the following code segments in program 1.1 (Figure 6), program 1.2 (Figure 7) and program 3 (Figure 8) are executed: //program 1.1. int a-1, b=2, c=3; printf("%d", (! (a>b)...
-
Adam Smith fue un escocs libre pensador propulsor de la llamada Teora Clsica, que expone en su principal publicacin "La riqueza de las naciones" su teora sobre: Seleccione una: a. Las Ventajas...
-
Write a summary of your understanding of the danielson framework and how you will prepare yourself for working with the framework.
-
For the circuit shown with following parameters, L-400 uH, R-2 92, Vin is within the range of 8 V to 16 V, Vout is desired to be 80 V constant Ts-200 us Primary winding self inductance: winding...
-
1) Plot the following functions in a single figure for 1 n 100. Ensure that the curves created are smooth. (You need to label the figure to receive full credit) a) y1 = cos (4n) b) y2 = cos (n) 5 n +...
-
Cornell and Roberts are partners who agree to admit Stanley to their partnership. Cornell has a capital balance of $80,000 and Roberts has a capital balance of $120,000. Cornell and Roberts share net...
-
Janet Cosgrove is the manager of Saratoga Sporting Goods, a division of Global Sports. Cosgroves division sells a variety of sporting goods and supplies to wholesalers and retail chains throughout...
-
Farm Fresh manufactures a variety of animal food products from alfalfa pellets. The firm has determined that its EOQ is 80,000 pounds of pellets. Based on the EOQ, the firms annual ordering cost for...
-
You are employed by a firm engaging in heavy manufacturing. Its direct materials are sourced globally, but its nonoperating inputs are sourced from a variety of U.S. vendors. You have been charged...
-
Reconsider Parts (a) through (f) of Problem 2. For each "true" statement, develop a mathematical proof based on the time value of money factor equations from Table 2.6 in Chapter 2. Data from problem...
-
Determine whether each of the following is true or false. In each case, assume \(P\) is located at \(t=0\) and \(F\) is located at \(t=n\), and the \(A\) s are spread uniformly over the planning...
-
Reconsider the data from Problem 4. Management has expressed some concern over the life of the project and the impact of possible early termination. As a result, you have developed additional data...
Study smarter with the SolutionInn App