Accounting Question

Uncategorized

Assignment Instructions

You have been hired as the new budget controller for Banderhouse Inc., a manufacturing firm that makes insulated pet houses from injected molded plastic. The firm has been in business for two years and currently makes one product, the Deluxe house. You are tasked with creating a master budget for the first quarter. It will consist of the operating budget and the financial budget with the following components:

Sales budget

Production budget

Direct materials purchase budget

Direct labor budget

Overhead budget

Selling and administrative expenses budget

Ending finished goods inventory budget

Cost of goods sold budget

Budgeted income statement

Cash budget

In a 400-800-word document, present your master budget to the company executives. It should include a title page with your name, company name, course name and submission date. All budgets should be in table format. An explanatory narrative should be included to describe computations made in each budget. Each narrative should be placed next to its corresponding budget table.

Pertinent Information

Unit selling price $235

Projected sales in units for the first quarter

MonthSalesJanuary50,000February60,000March70,000April70,000May70,000

Direct labor usage data:

Direct labor per unitdirect labor per hour3 hours$12.50

Direct material usage data:

Direct Material UsagePer UnitUnit CostPlastic pellets10 lbs$7Insulation5 lbs$3

Inventory policy requires that there are sufficient materials on hand at the beginning of the month to produce 50% of that months estimated sales. This was the case on January 1.

Monthly overhead data:

Fixed CostVariable CostPower$1.00Supplies.40Maintenance25,000.50Supervision16,000Depreciation100,000Taxes15,000Other10,0001.40

Monthly overhead is estimated using a flexible budget formula and is measured in direct labor hours.

Monthly selling and administrative data:

Fixed CostVariable CostSalaries$20,000Depreciation10,000Shipping1.00Other10,000.50

Monthly selling and administrative expenses are estimated using a flexible budget formula and are measured in units sold.

Finished goods inventory:

MonthUnitsUnit CostJanuary 140,000$166

Desired ending inventory for each month is 80 percent of next month’s sales.

All sales and purchases are for cash. The cash balance on January 1 was $500,000. Banderhouse Inc. requires a minimum month cash balance of $1000. If there is a cash shortage, money is borrowed at a rate of 10 percent and is repaid at the end of the quarter along with the interest due. Cash borrowed at the end of the quarter is repaid at the end of the following quarter. On January 1, there were no loans.

Related Lessons

The following lessons can help you get started with this assignment.

Master Budget in Accounting: Definition, Components & Example

Sales Budget: Definition and Examples

Manufacturing Overhead Budget: Definition, Preparation and Example

Finished Goods Inventory: Calculation & Formula

Cost of Goods Sold Journal Entries

Preparing a Budgeted Income Statement

Continue to order Get a quote

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.