Donahue Company is preparing budgets for the third quarter ending Sept 30, 2019. Budgeted sales for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Donahue Company is preparing budgets for the third quarter ending Sept 30, 2019. Budgeted sales for the next five months are: • July 20,AAA units • Aug 50,BBB units Sept 30,CCC units • Oct 25,DDD units • Nov 15,000 units See instructions in table below: Group Member No. 1. 2. 3. 4. ID Number S00003206 S11036589 S90250055 S11011034 First Name Mickey Donald Yogi Scooby Last Name Mouse Duck Bear Doo July 20,AAA units becomes 20,206 units. AAA is the last three digits of Member 1 s ID. Aug 50,BBB units becomes 50,589 units. BBB is the last three digits of Member 2 s ID. Sept 30,CCC units becomes 30,055 units. CCC is the last three digits of Member 3 s ID. Oct 25,DDD units become 25,034 units. DDD is the last three digits of Member 4 s ID. NOTE that if your group has three members only, then use the value of 25,000 units for Oct. Nov remains at 15,000 units. The selling price is $15 per unit. All sales are on account. Donahue s collection pattern is 60% collected in the month of sale and remaining amount in the month following sale. The June 30 Accounts Receivable balance of $50,000 will be collected in full. The management at Donahue Company wants ending Finished Goods Inventory to be equal to 25% of the following month s budgeted sales in units. At Donahue Company, five pounds of material are required per unit of product. Management wants materials on hand at the end of each month equal to 15% of the following month s production. Material cost is $0.50 per pound. 30% of a month s purchases is paid for in the month of purchase and the remainder is paid in the following month. The June 30 Accounts Payable balance is $20,000. At Donahue, each unit of product requires 0.06 hours (3.6 minutes) of direct labor. The company has a no layoff policy and in exchange for the no layoff policy, workers agree to a wage rate of $15 per hour regardless of the hours worked (no overtime pay). For the next three months, the direct labor workforce will be paid for a minimum of 2,000 hours per month. At Donahue, manufacturing overhead is applied to units of product on the basis of direct labor hours. The variable manufacturing overhead rate is $25 per direct labor hour. Fixed manufacturing overhead is $40,000 per month and includes $10,000 of non-cash costs. At Donahue, the selling and administrative expenses budget is divided into variable and fixed components. The variable selling and administrative expenses are $0.55 per unit sold. Fixed selling and administrative expenses are $60,000 per month. The fixed selling and administrative expenses include $15,000 in costs that are not cash outflows of the current month. The company: Has a July 1 cash balance of $55,000 • Maintains a minimum cash balance of $35,000 ● Borrows on the first day of the month and repays loans on the last day of the quarter Maintains a 12% open line of credit for $95,000 • Pays a cash dividend of $45,000 in Aug • Cash purchases of equipment, $155,200 in July and $54,800 in Sept, respectively ● Donahue reported the following account balances prior to preparing its budgeted financial statements: • Land - $65,000 • Equipment - $180,000 • • Retained earnings - $X* Ordinary shares - $195,000 *This Retained earnings figure will be the amount needed to balance off your balance sheet on June 30th i.e. the closing balances on June 30th before you step into the third quarter. With the information provided, assist Donahue Company in setting up their Master Budget . To do this, you will need to prepare the following budgets for the third quarter of the year: 1. Sales Budget 2. Expected Cash Collections 3. Production Budget 4. Direct Materials Budget 5. Expected Cash Disbursements for Materials 6. Direct Labour Budget 7. Manufacturing Overhead Budget 8. Ending Finished Goods Inventory Budget 9. Selling & Administration Expenses Budget 10. Cash Budget 11. Budgeted Income Statement 12. Budgeted Balance Sheet* *For the balance sheet as at Sept 30th, there will be a difference between the final totals. This is due to calculations based on rounded off units. To balance the totals, simply close off this difference to the Retained Earnings account. Donahue Company is preparing budgets for the third quarter ending Sept 30, 2019. Budgeted sales for the next five months are: • July 20,AAA units • Aug 50,BBB units Sept 30,CCC units • Oct 25,DDD units • Nov 15,000 units See instructions in table below: Group Member No. 1. 2. 3. 4. ID Number S00003206 S11036589 S90250055 S11011034 First Name Mickey Donald Yogi Scooby Last Name Mouse Duck Bear Doo July 20,AAA units becomes 20,206 units. AAA is the last three digits of Member 1 s ID. Aug 50,BBB units becomes 50,589 units. BBB is the last three digits of Member 2 s ID. Sept 30,CCC units becomes 30,055 units. CCC is the last three digits of Member 3 s ID. Oct 25,DDD units become 25,034 units. DDD is the last three digits of Member 4 s ID. NOTE that if your group has three members only, then use the value of 25,000 units for Oct. Nov remains at 15,000 units. The selling price is $15 per unit. All sales are on account. Donahue s collection pattern is 60% collected in the month of sale and remaining amount in the month following sale. The June 30 Accounts Receivable balance of $50,000 will be collected in full. The management at Donahue Company wants ending Finished Goods Inventory to be equal to 25% of the following month s budgeted sales in units. At Donahue Company, five pounds of material are required per unit of product. Management wants materials on hand at the end of each month equal to 15% of the following month s production. Material cost is $0.50 per pound. 30% of a month s purchases is paid for in the month of purchase and the remainder is paid in the following month. The June 30 Accounts Payable balance is $20,000. At Donahue, each unit of product requires 0.06 hours (3.6 minutes) of direct labor. The company has a no layoff policy and in exchange for the no layoff policy, workers agree to a wage rate of $15 per hour regardless of the hours worked (no overtime pay). For the next three months, the direct labor workforce will be paid for a minimum of 2,000 hours per month. At Donahue, manufacturing overhead is applied to units of product on the basis of direct labor hours. The variable manufacturing overhead rate is $25 per direct labor hour. Fixed manufacturing overhead is $40,000 per month and includes $10,000 of non-cash costs. At Donahue, the selling and administrative expenses budget is divided into variable and fixed components. The variable selling and administrative expenses are $0.55 per unit sold. Fixed selling and administrative expenses are $60,000 per month. The fixed selling and administrative expenses include $15,000 in costs that are not cash outflows of the current month. The company: Has a July 1 cash balance of $55,000 • Maintains a minimum cash balance of $35,000 ● Borrows on the first day of the month and repays loans on the last day of the quarter Maintains a 12% open line of credit for $95,000 • Pays a cash dividend of $45,000 in Aug • Cash purchases of equipment, $155,200 in July and $54,800 in Sept, respectively ● Donahue reported the following account balances prior to preparing its budgeted financial statements: • Land - $65,000 • Equipment - $180,000 • • Retained earnings - $X* Ordinary shares - $195,000 *This Retained earnings figure will be the amount needed to balance off your balance sheet on June 30th i.e. the closing balances on June 30th before you step into the third quarter. With the information provided, assist Donahue Company in setting up their Master Budget . To do this, you will need to prepare the following budgets for the third quarter of the year: 1. Sales Budget 2. Expected Cash Collections 3. Production Budget 4. Direct Materials Budget 5. Expected Cash Disbursements for Materials 6. Direct Labour Budget 7. Manufacturing Overhead Budget 8. Ending Finished Goods Inventory Budget 9. Selling & Administration Expenses Budget 10. Cash Budget 11. Budgeted Income Statement 12. Budgeted Balance Sheet* *For the balance sheet as at Sept 30th, there will be a difference between the final totals. This is due to calculations based on rounded off units. To balance the totals, simply close off this difference to the Retained Earnings account.
Expert Answer:
Related Book For
College Accounting
ISBN: 978-1111528126
11th edition
Authors: Tracie Nobles, Cathy Scott, Douglas McQuaig, Patricia Bille
Posted Date:
Students also viewed these accounting questions
-
1. The primary objective of financial reporting is to provide information useful for making investment and lending decisions. To be useful, financial information must possess certain characteristics....
-
A project which requires an initial outlay of RM9,000 will produce the following annual inflows: [Sebuah projek yang memerlukan perbelanjaan permulaan sebanyak RM9,000 akan menghasilkan aliran masuk...
-
Introduction to Financial Accounting Eleventh Edition Charles T Horngren Stanford University Gary L Sundem University of Washington John A Elliott University of Connecticut Donna R Philbrick Portland...
-
Current Attempt in Progress Joseph Taylor recorded the following transactions during the month of April. Apr. 3 16 20 Cash Service Revenue Rent Expense Cash Salaries and Wages Expense Cash 3,020 690...
-
For the r.v.s X1, X2,..., Xn, set Sk = (kj=1 X j, k = 1,...., n, and show that (X1, X2,...., Xn) = (S1, S2,...Sn).
-
As a manager, what can you do to enhance the quality of group decision-making?
-
Question 9 indicated high vibration on the sleeve bearing and bracket in the axial vibration. What damage would this have caused?
-
Selected account balances and transactions of Alpine Manufacturing Co. follow: May Transactions: a. Purchased raw materials and factory supplies on account at costs of $45,000 and $10,000,...
-
What are the potential benefits of integrating elements from both positive psychology and clinical psychology? Please include references
-
Salazar Company is a job-order costing firm that uses activity-based costing to apply overhead to jobs. Salazar identified three overhead activities and related drivers. Budgeted information for the...
-
The limit of average rates of change from x to x + (delta)x approahces the instantaneous rate of change. This is given by the following mathematical expression. f(x + Ax) f(x) lim Ax Ax+0 lim [ {f(x...
-
Seth is not obligated to sell. One may assume that this would be considered a valid contract using the statue of frauds clause under the UCC. A signed document was sent by Nina and Seth did not...
-
One of your reading assignments in Unit 1 was Chapter 1 of the course textbook. That included a five-step ethical decision-making process, which is listed below. You might consider rereading that...
-
What are the highest appellate courts in the state of Texas? Regarding jurisdiction, what types of cases do these courts review?
-
Develop a resume for a police officer position of interest that contains a summary of qualifications, education, work history, additional experience, specialized training, organizational involvement,...
-
A ball is dropped from a cliff that is 256 feet high. The height of the ball (in feet) after t seconds is given by the formula h(t)=256-16t2. How many seconds (to the nearest tenth) will it take for...
-
The population of Detroit has decreased 34% over the past 20 years. Today there are only 675,000 people in the city. What was the population 20 years ago? Round to the nearest person.
-
A local politician is concerned that a program for the homeless in her city is discriminating against blacks and other minorities. The following data were taken from a random sample of black and...
-
On June 1, Rangel Supplys Accounts Receivable balance was $ 25,325. The balance of the contra account Allowance for Doubtful Accounts was $ 1,520 credit. On June 20, the account balance of McIntyres...
-
What are the advantages and disadvantages of corporations issuing bonds compared with issuing stock?
-
Williams Company pays its employees time- and- a- half for hours worked in excess of 40 per week. The information available from time records and employees individual earnings records for the pay...
-
The radius of curvature of one surface of a glass lens \((n=1.45)\) is \(1.50 \mathrm{~m}\). If sunlight is focused at a point \(0.300 \mathrm{~m}\) away from the lens, what is the radius of...
-
A plano-convex lens has a focal length of \(170 \mathrm{~mm}\), and the material of which the lens is made has an index of refraction of 1. 6. What is the radius of curvature of the convex surface?
-
The two surfaces of a double convex, thin lens made of plastic each have an absolute value of radius of curvature of \(1.8 \mathrm{~mm}\). If the focal length of the lens is \(4.5 \mathrm{~mm}\),...
Study smarter with the SolutionInn App