Solution-Create an ending finished goods inventory budget

Create an ending finished goods inventory budget for quarter

Assignment Help Managerial Accounting

Reference no: EM132659130

CASE STUDY - BUDGETING

Month Unit Sales

July 20,000

August 35,000

ABC Corporation has the following data to be used in budgeting:

September 25,000

October 30,000

Sales price per unit is P180
Plans are to have an inventory of finished product equal to 20% of the unit sales for the next month. There was 4,000 units in beginning inventory on July 1st.
Three pounds of materials are required for each unit produced. Each pound of material costs P20. Inventory levels for materials equal 30% of the needs for the next month.
Desired ending inventory for September is 25,200 pounds of material. Beginning inventory
for July was 20,700 pounds of material.
Each unit requires 0.6 hours of direct labor and the average wage rate is P16 per hour.
Variable overhead rate is P3.50 per direct labor hour. There is also fixed overhead of
P22,000 per month.
The company pays a 3% commission on sales.

Company has fixed selling and administrative expenses as follows:

Rent P6,000/month

Utilities P1,200/month

Advertising P400/month

Office Salaries P35,000/month

Requirements:

Question A. Make a sales budget for July, August, and September and in total for the quarter.

Question B. Make production budgets for July, August, and September and in total for the quarter.

Question C. Make a direct materials purchases budget in pounds and dollars for July, August, and September and in total for the quarter.

Question D. Make a direct labor budget in hours and total cost for July, August and September and in total for the quarter.

Question E. Make an overhead budget for July, August and September and in total for the quarter.

Question F. Make a selling and administrative expenses budget for July, August and September and in total for the quarter.

Question G. Make an ending finished goods inventory budget for the quarter (Hint: You have already calculated the desired ending finished goods inventory quantity. Assume a stable per unit rate and round the per unit fixed factory overhead rate to two decimal places.)

Question H. Make a cost of goods sold budget for the quarter

Question I. Make a budged income statement for the quarter-the company falls into the 35% tax bracket for income taxes.

Reference no: EM132659130

Questions Cloud

Should morris-meyer lease or borrow and buy the equipment : Assuming that the lease can be arranged, should Morris-Meyer lease or borrow and buy the equipment? Explain. Round your answer to the whole number.

How to record the transactions in the ledger accounts : Record the above transactions in the ledger accounts. 2 Jan: He bought materials on credit for $700 from J martin. He sold goods for $1100 to K Lemon on credit

Which the activities involved during the negotiation stage : Which the activities involved during the negotiation stage of a consulting engagement include the following except? Identification of the end product of asset

Justify the implication and reasoning behind the trend : The table below shows the trend of interest rate in the U.S. in 2020. By using your own words, justify the implication and reasoning behind the trend.

Create an ending finished goods inventory budget for quarter : Create an ending finished goods inventory budget for the quarter (Hint: You have already calculated the desired ending finished goods inventory quantity.

Make a table of ratios for both years for both companies : Make a table of ratios for both the years for both companies. Interpret and compare the results of the ratios of both the years for both companies

How to show the ending balances in accounts receivable : How to Show the ending balances in accounts receivable, allowance for uncollectible accounts and net accounts receivable at October 31.

Journalize and post the july transactions : Journalize and post the July transactions.Paid $1,000 cash on amount owed on truck and $800 on amount owed on cleaning supplies.

What figures should be included in the barletts financial : Details of Barletts insurance policy, What figures should be included in the barletts financial statements for the year ended 30 june 20x6?

User Account

All Pages

Create an ending finished goods inventory budget for quarter

Reference no: EM132659130

Reference no: EM132659130

Questions Cloud

Reviews

Write a Review

Managerial Accounting Questions & Answers

Manage budgets and financial plans

Prepare a retained earnings statement

Prepare a master budget for the three-month period

Construct the companys direct labor budget

Evaluate the predetermined overhead rate

Determine the company''s bid

Compute the pool rates for the different activities

Prepare Company financial statements

Prepare an analysis of terracycles

Discuss the ethical issues

Political resources in emerging markets

Management accounting - ehsan electronics company

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT