Required: - sales budget - production budget - direct materials budget - direct labor budget - factory
Fantastic news! We've Found the answer you've been seeking!
Question:
Required:sales budgetproduction budgetdirect materials budgetdirect labor budgetfactory overhead budgetselling expense budgetgeneral and administrativeexpense budgetschedule of cash receiptsschedule of cash payments for direct materialscash budgetbudgeted income statement for entire second quarternot monthlybudgeted balance sheet at June
Transcribed Image Text:
Assets Balance Sheet March 31 Liabilities and Equity Cash $ 64,000 Liabilities Accounts receivable Raw materials inventory 551,040 Accounts payable $ 321,600 157,600 Loan payable Finished goods inventory Equipment 520,864 Long-term note payable 12,000 800,000 $ 1,133,600 $ 960,000 Equity Less: Accumulated depreciation 240,000 720,000 Common stock Retained earnings 536,000 343,904 879,904 Total assets $ 2,013,504 Total liabilities and equity $ 2,013,504 To prepare a master budget for April, May, and June, management gathers the following information. a. Sales for March total 32,800 units. Budgeted sales in units follow: April, 32,800; May, 31,200, June, 32,000; and July, 32,800. The product's selling price is $24.00 per unit and its total product cost is $19.85 per unit. b. Raw materials inventory consists solely of direct materials that cost $20 per pound. Company policy calls for a given month's ending materials inventory to equal 50% of the next month's direct materials requirements. The March 31 raw materials inventory is 7,880 pounds. The budgeted June 30 ending raw materials inventory is 6,400 pounds. Each finished unit requires 0.50 pound of direct materials. c. Company policy calls for a given month's ending finished goods inventory to equal 80% of the next month's budgeted unit sales. The March 31 finished goods inventory is 26,240 units. d. Each finished unit requires 0.50 hour of direct labor at a rate of $15 per hour. e. The predetermined variable overhead rate is $2.70 per direct labor hour. Depreciation of $32,000 per month is the only fixed factory overhead item. f. Sales commissions of 8% of sales are paid in the month of the sales. The sales manager's monthly salary is $4,800. g. Monthly general and administrative expenses include $19,200 for administrative salaries and 0.9% monthly interest on the long- term note payable. h. The company budgets 30% of sales to be for cash and the remaining 70% on credit. Credit sales are collected in full in the month following the sale (no credit sales are collected in the month of sale). i. All raw materials purchases are on credit, and accounts payable are solely tied to raw materials purchases. Raw materials purchases are fully paid in the next month (none are paid in the month of purchase). j. The minimum ending cash balance for all months is $64,000. If necessary, the company borrows enough cash using a loan to reach the minimum. Loans require an interest payment of 1% at each month-end (before any repayment). If the month-end preliminary cash balance exceeds the minimum, the excess will be used to repay any loans. k. Dividends of $16,000 are budgeted to be declared and paid in May. I. No cash payments for income taxes are budgeted in the second calendar quarter. Income tax will be assessed at 35% in the quarter and budgeted to be paid in the third calendar quarter. m. Equipment purchases of $160,000 are budgeted for the last day of June. Required: 1 Sales budget Assets Balance Sheet March 31 Liabilities and Equity Cash $ 64,000 Liabilities Accounts receivable Raw materials inventory 551,040 Accounts payable $ 321,600 157,600 Loan payable Finished goods inventory Equipment 520,864 Long-term note payable 12,000 800,000 $ 1,133,600 $ 960,000 Equity Less: Accumulated depreciation 240,000 720,000 Common stock Retained earnings 536,000 343,904 879,904 Total assets $ 2,013,504 Total liabilities and equity $ 2,013,504 To prepare a master budget for April, May, and June, management gathers the following information. a. Sales for March total 32,800 units. Budgeted sales in units follow: April, 32,800; May, 31,200, June, 32,000; and July, 32,800. The product's selling price is $24.00 per unit and its total product cost is $19.85 per unit. b. Raw materials inventory consists solely of direct materials that cost $20 per pound. Company policy calls for a given month's ending materials inventory to equal 50% of the next month's direct materials requirements. The March 31 raw materials inventory is 7,880 pounds. The budgeted June 30 ending raw materials inventory is 6,400 pounds. Each finished unit requires 0.50 pound of direct materials. c. Company policy calls for a given month's ending finished goods inventory to equal 80% of the next month's budgeted unit sales. The March 31 finished goods inventory is 26,240 units. d. Each finished unit requires 0.50 hour of direct labor at a rate of $15 per hour. e. The predetermined variable overhead rate is $2.70 per direct labor hour. Depreciation of $32,000 per month is the only fixed factory overhead item. f. Sales commissions of 8% of sales are paid in the month of the sales. The sales manager's monthly salary is $4,800. g. Monthly general and administrative expenses include $19,200 for administrative salaries and 0.9% monthly interest on the long- term note payable. h. The company budgets 30% of sales to be for cash and the remaining 70% on credit. Credit sales are collected in full in the month following the sale (no credit sales are collected in the month of sale). i. All raw materials purchases are on credit, and accounts payable are solely tied to raw materials purchases. Raw materials purchases are fully paid in the next month (none are paid in the month of purchase). j. The minimum ending cash balance for all months is $64,000. If necessary, the company borrows enough cash using a loan to reach the minimum. Loans require an interest payment of 1% at each month-end (before any repayment). If the month-end preliminary cash balance exceeds the minimum, the excess will be used to repay any loans. k. Dividends of $16,000 are budgeted to be declared and paid in May. I. No cash payments for income taxes are budgeted in the second calendar quarter. Income tax will be assessed at 35% in the quarter and budgeted to be paid in the third calendar quarter. m. Equipment purchases of $160,000 are budgeted for the last day of June. Required: 1 Sales budget
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The management of Zigby manufacturing prepared the following estimated balance sheet for March, 2013: To prepare a master budget for April, May, and June of 2013, management gathers the following...
-
Payne Company's management requests that we prepare its master budget. The budget is to cover the months of April, May, and June. Its balance sheet at March 31 follows. Additional Information a....
-
A particle is described by the normalized wave function (x, y, z) = Axe-ax2 e -y2 e-yz2', where A, a, , and are all real, positive constants. The probability that the particle will be found in the...
-
In 1995, Lockheed was prosecuted by the U.S. government for allegedly paying $1 million to a member of the Egyptian parliament in order to sell its military jets to Egypt's armed forces. The company...
-
When the EOQ formula is solved, what does the result indicate?
-
What are some indicators that a digital device has been infected?
-
(Terminology, Relationships, Computations, Entries) Complete the following statements by filling in the blanks. (a) In a period in which a taxable temporary difference reverses, the reversal will...
-
Mr. Amar is 30 year old, newly married and a successful actor in the Indian film industry. Right from his struggling days, Amar always saved a part of his income and invested in safe instruments like...
-
You have signed a contract with the client to provide manpower for 50 USD/hour. Moreover, you will also be reimbursed for any costs incurred, along with a fixed fee of 25,000 USD. What kind of...
-
A person flies from city A to city B at a speed of 600 km per hour and returns to city A by train at a speed of 120 km per hour. Find out his average speed. Explain the method you used for...
-
From the law of mass-action (n.p = n), piece of intrinsic semiconductor with the number of electron concentration 106 cm 3, and n; = 1.8 x 10 cm-3. Then answer: (a) What is the type of the used...
-
A car moving with a 50m/s initial velocity is being decelerated by deflecting a water jet through. If we like to stop the car in 10 meters, what should be the jet velocity U? Ajet=10cm 500 M-10kg TT...
-
A particle with mass 3 kg is lifted by a smooth rotating arm along a smooth path in the vertical plane from position A to B. The path between A and B is a circular ramp with radius 600 mm which is...
-
A 160 kg carton is pulled up 3.00 m and low-friction plank onto the back of a truck as shown. JANE'S CARGO 110195 5. If the back of the truck is 1.25 m above the ground, what force is required to...
-
Using the knowledge@wharton site, review several articles and select one that showcases an authentic, transformational, or servant leader. Take a moment to scroll through the articles to find one...
-
If the jobs displayed in Table 18.24 are processed using the earliestdue-date rule, what would be the lateness of job C? TABLE 18.24 Processing Times and Due Dates for Five Jobs Job C D E...
-
Write a program in \(\mathrm{R}\) that generates \(b\) samples of size \(n\) from a specified distribution \(F\). For each sample compute the statistic \(Z_{n}=n^{1 / 2}...
-
Write a program in \(\mathrm{R}\) that generates \(b\) samples of size \(n\) from a \(\mathbf{N}\left(\mathbf{0}, \boldsymbol{\Sigma}_{n}ight)\) distribution where...
-
Using a probability theory argument, show that the sum of all elements of any covariance matrix is non-negative.
Study smarter with the SolutionInn App