Dye-Aspora, Inc manufactures a red industrial dye. The company is preparing its master budget for the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Dye-Aspora, Inc manufactures a red industrial dye. The company is preparing its master budget for the first quarter and has presented you with the following information. 1. The December 31, 20XX, balance sheet for the company follows. DYE-ASPORA, Incorporated Balance Sheet December 31, 20XX Assets Liabilities and Stockholder Equity Cash $8,050 Accounts Payable $20,200 Accounts Receivable 53,600 Notes Payable 25,000 Raw Materials 2,000 Dividends Payable 25,000 Inventory Finished Goods Total 4,375 70,200 Inventory Liabilities Prepaid Insurance 1,600 Common Stock 80,000 Building 300,000 Paid-in Capital 30,000 Retained Acc Depreciation (95,000) 94,425 205,000 Earnings 204,425 Total Liabilities and Total Assets $274,625 $274,625 Equity 2. The Accounts Receivable balance on December 31 st represents the remaining balances of November and December sales: $80,000 and $104,000, respectively. 3. Estimated sales in gallons of dye for January through May follow: January 8,000 February 9,000 March 11,000 April 12,000 Мay 11,000 Each gallon of dye sells for $16.00. 4. The collection pattern for accounts receivable is as follows: 60% in the month of sale, 25% the month after sale, and 15% the second month after sale. Dye-Aspora expects no bad debts and gives no cash discounts. 5. Each gallon of dye has the following standard quantities and costs for direct materials and direct labor: Quantity Cost/rate Std Cost Mordant (DM) $2.00 $15.00 $2.80 $4.50 1.40 Gal Direct labor 0.30 Hr Some evaporation loss occurs during processing. Variable overhead (VOH) is applied basis machine-hours. The processing of 1 gallon of dye takes 3 MH. The variable overhead rate is $0.10 per MH. VOH is entirely of utility costs. FOH is applied per gallon based on an expected annual capacity of 120,000 gallons. Fixed overhead is incurred evenly throughout the year. Fixed overhead per year is composed of the following costs: $84,600 17,400 4,800 Salaries Utilities Insurance-factory Depreciation-factory 31,200 6. There is no beginning work in process inventory. All work in process is completed in the period in which it is started. Raw materials inventory at the beginning of the year consists of 1,000 gallons of Mordant. There are 500 gallons of dye in finished goods inventory at the beginning of the year carried at standard cost. 7. Accounts Payable relates solely to raw material and is paid 60 percent in the month of purchase and 40 percent in the month after purchase. No discounts are given for prompt рayment. 8. The dividend will be paid in January. 9. A new piece of equipment costing $10,000 will be purchased on March 1. Payment of 60 percent will be made in March and 40 percent in April. The equipment has a useful life of three years and will have no salvage value. The equipment will be placed in service April 2. 10. The note payable has a 6% interest rate; interest is paid at the end of each month. The principal of the note is repaid as cash is available to do so. 11. Dye-Aspora's management has set a minimum cash balance at $6,000. Borrowings are made in $1000 increments. The line of credit is at 9% per year. 12. The ending finished goods inventory should include 25 percent of the next month's needs. The ending inventory of raw materials also should be 20 percent of the next month's needs. This is not true at the beginning of January due to a miscalculation in sales for December. 13. Monthly selling and administrative costs are paid cash. Per month costs are as ows: Salaries $15,000 Utilities 1800 Office Rent 8,000 Required: Prepare a master budget, by month, for the first quarter including quarterly totals and the pro- forma income statement and balance sheet as of March 31st. Dye-Aspora, Inc manufactures a red industrial dye. The company is preparing its master budget for the first quarter and has presented you with the following information. 1. The December 31, 20XX, balance sheet for the company follows. DYE-ASPORA, Incorporated Balance Sheet December 31, 20XX Assets Liabilities and Stockholder Equity Cash $8,050 Accounts Payable $20,200 Accounts Receivable 53,600 Notes Payable 25,000 Raw Materials 2,000 Dividends Payable 25,000 Inventory Finished Goods Total 4,375 70,200 Inventory Liabilities Prepaid Insurance 1,600 Common Stock 80,000 Building 300,000 Paid-in Capital 30,000 Retained Acc Depreciation (95,000) 94,425 205,000 Earnings 204,425 Total Liabilities and Total Assets $274,625 $274,625 Equity 2. The Accounts Receivable balance on December 31 st represents the remaining balances of November and December sales: $80,000 and $104,000, respectively. 3. Estimated sales in gallons of dye for January through May follow: January 8,000 February 9,000 March 11,000 April 12,000 Мay 11,000 Each gallon of dye sells for $16.00. 4. The collection pattern for accounts receivable is as follows: 60% in the month of sale, 25% the month after sale, and 15% the second month after sale. Dye-Aspora expects no bad debts and gives no cash discounts. 5. Each gallon of dye has the following standard quantities and costs for direct materials and direct labor: Quantity Cost/rate Std Cost Mordant (DM) $2.00 $15.00 $2.80 $4.50 1.40 Gal Direct labor 0.30 Hr Some evaporation loss occurs during processing. Variable overhead (VOH) is applied basis machine-hours. The processing of 1 gallon of dye takes 3 MH. The variable overhead rate is $0.10 per MH. VOH is entirely of utility costs. FOH is applied per gallon based on an expected annual capacity of 120,000 gallons. Fixed overhead is incurred evenly throughout the year. Fixed overhead per year is composed of the following costs: $84,600 17,400 4,800 Salaries Utilities Insurance-factory Depreciation-factory 31,200 6. There is no beginning work in process inventory. All work in process is completed in the period in which it is started. Raw materials inventory at the beginning of the year consists of 1,000 gallons of Mordant. There are 500 gallons of dye in finished goods inventory at the beginning of the year carried at standard cost. 7. Accounts Payable relates solely to raw material and is paid 60 percent in the month of purchase and 40 percent in the month after purchase. No discounts are given for prompt рayment. 8. The dividend will be paid in January. 9. A new piece of equipment costing $10,000 will be purchased on March 1. Payment of 60 percent will be made in March and 40 percent in April. The equipment has a useful life of three years and will have no salvage value. The equipment will be placed in service April 2. 10. The note payable has a 6% interest rate; interest is paid at the end of each month. The principal of the note is repaid as cash is available to do so. 11. Dye-Aspora's management has set a minimum cash balance at $6,000. Borrowings are made in $1000 increments. The line of credit is at 9% per year. 12. The ending finished goods inventory should include 25 percent of the next month's needs. The ending inventory of raw materials also should be 20 percent of the next month's needs. This is not true at the beginning of January due to a miscalculation in sales for December. 13. Monthly selling and administrative costs are paid cash. Per month costs are as ows: Salaries $15,000 Utilities 1800 Office Rent 8,000 Required: Prepare a master budget, by month, for the first quarter including quarterly totals and the pro- forma income statement and balance sheet as of March 31st.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Damon Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Damon Manufacturing's operations: Current Assets as of December 31 (prior...
-
Presidio Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Presidio Manufacturing's operations: Current assets as of December 31...
-
Cicek Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain to Cicek Manufacturings operations: Current Assets as of December 31 (prior...
-
At DEF Insurance Company, agents are employees of the company who are paid a salary plus commissions. This is an example of what type of insurance marketing system? OA) Fraternal B) Direct response...
-
What is a flexible exchange rate and how does it work?
-
Gwen Jones owns and operates GJ Transport Co. During the past year, Gwen incurred the following costs related to an 18-wheel truck: 1. Changed engine oil. 2. Installed a television in the sleeping...
-
Identify the research scenario, including the general area of focus. Develop a hypothetical research scenario that would necessitate the use of the Action Research Approach and a Posttest With a...
-
Windhoek Mines, Ltd., of Namibia, is contemplating the purchase of equipment to exploit a mineral deposit on land to which the company has mineral rights. An engineering and cost analysis has been...
-
(Parent reference for BST) Revise TreeNode by adding a reference to a nodes parent, as shown below: BinaryTree.TreeNode #element: T #left: TreeNode #right: TreeNode #*parent: TreeNode Create a test...
-
Consider the following linear programming problem Max 8X + 7Y s.t. 15X + 5Y < 75 10X + 6Y < 60 X + Y < 8 X, Y 0 a. Use a graph to show each constraint and the feasible region. b. Identify the...
-
The University of Danville is a private not-for-profit university that starts the current year with $761,000 in net assets: $426,000 unrestricted, $229,000 temporarily restricted, and $106,000...
-
Suppose that Congress passes legislation that establishes a tax credit for small businesses and tax incentives for all businesses that invest in new plant and equipment. a) What is the anticipated...
-
Company K purchased $1 million face value of bonds issued by company J on 1 July 2015 at purchase cost of $1.05 million. The bond had coupon of 6% payable semi-annually and matures on 30 June 2017....
-
If Gemini has a floating rate loan and enters into a pay-fixed-and-receive-floating interest swap transaction with the same principal amount, which of the following statements is the most appropriate...
-
Explain the following terms: (a) Grant date (b) Measurement date (c) Vesting date (d) Vesting conditions (e) Forfeiture rate
-
The consequences of climate change on the economy is a popular topic in the media. Suppose that a series of wildfires destroys crops in the western states at the same time a hurricane destroys...
-
find out the common element between two matrices given by user by c language
-
2. Assume a person bends forward to lift a load "with his back" as shown in Figure P12.42a. The person's spine piv- ots mainly at the fifth lumbar vertebra, with the principal supporting force...
-
Reynolds, Inc., manufactures only two products, Medium (42- inch) and Large (63- inch) TVs. To generate adequate profit and cover its expenses throughout the value chain, Reynolds prices its TVs at...
-
1. George just hit the jackpot in Las Vegas and won $ 55,000! If he invests it now, at a 12% interest rate, how much will it be worth 15 years from now? 2. Zach would like to have $ 4,000,000 saved...
-
Carmichael Industries is in the process of analyzing its manufacturing overhead costs. Carmichael Industries is not sure if the number of units produced or the number of direct labor (DL) hours is...
-
Suppose that \(X\) is a discrete random variable that takes on the values \(\{0,1\}\) and has characteristic function \(\psi(t)=\cos (t)\). Use Theorem 2.29 to find the probability that \(X\) equals...
-
Suppose that \(X\) is a discrete random variable that takes on positive integer values and has characteristic function \[\psi(t)=\frac{p \exp (i t)}{1-(1-p) \exp (i t)}\] Use Theorem 2.29 to find the...
-
Suppose that \(X\) is a continuous random variable that takes on real values and has characteristic function \(\psi(t)=\exp (-|t|)\). Use Theorem 2.28 to find the density of \(X\). Theorem 2.28....
Study smarter with the SolutionInn App