Question
In: Accounting
You need to prepare the budget for Yellow tree for the quarter ending June 2018. The...
You need to prepare the budget for Yellow tree for the quarter ending June 2018. The budget must be prepared monthly. The quarter consists of 13 weeks.
The forecasted sales are as follows:
|
April 4weeks |
May 5weeks |
June 4weeks |
July 4weeks |
|
| sales units | 1,250 | 1,500 | 1,750 | 1,800 |
The company’s policy changed the inventory policy to keep closing inventory of completed units at 25% of the following month’s sales. Opening inventory on the 1st of April was 475 units.
The labour information is as follows:
Normal working hours - 8 hours per day.
Weekend work None, only if overtime is required.
Number of employees - 20 currently Additional 10 employees will be employed for the month of June.
Normal time rate - R32.50 per hour.
Overtime rate 30% above normal time rate per hour.
Hours per unit - 3 hours.
Required:
1. Calculate the production budget for the quarter.
2. Calculate the budgeted labour hours per month. Split the hours between normal time and overtime.
3. Calculate the budgeted labour cost monthly. Split the cost between normal time and overtime.
Solutions
ekkarill92 answered 1 year agoRelated Solutions
You need to prepare the budget for Yellow tree for the quarter ending June 2018. The...
You need to prepare the budget for Yellow tree for the quarter
ending June 2018. The budget must be prepared monthly. The quarter
consists of 13 weeks. The forecasted sales are as follows:
April 4 weeks May 5 weeks June 4 weeks July 4 weeks
Sales Units 1,250 1,500 1,750 1,800
The company’s policy changed the inventory policy to keep
closing inventory of completed units at 25% of the following
month’s sales. Opening inventory on the 1st of April was...
Question 3: [18 marks] You need to prepare the budget for Yellow tree for the quarter...
Question 3: [18 marks] You need to prepare the budget for Yellow
tree for the quarter ending June 2018. The budget must be prepared
monthly. The quarter consists of 13 weeks. The forecasted sales are
as follows: April 4 weeks May 5 weeks June 4 weeks July 4 weeks
Sales Units 1,250 1,500 1,750 1,800 The company’s policy changed
the inventory policy to keep closing inventory of completed units
at 25% of the following month’s sales. Opening inventory on the...
You need to prepare the budget forYellow tree for the quarter ending June2018. The budget must be preparedmonthly. The quarter consists of 13week
You need to prepare the budget forYellow tree for the quarter ending June2018. The budget must be preparedmonthly. The quarter consists of 13weeks. The forecasted sales are as
follows:
April
4 weeks
May
5 weeks
June
4 weeks
July
4 weeks
Sales Units
1,250
1,500
1,750
1,800
The company’s policy changed theinventory policy to keep closing inventoryof completed units
at 25% of
thefollowing month’s sales. Openinginventory on
the 1st of
April was 475units. The labour information
is as follows:
Normal workinghours
8 hours per day
Weekend work
None, only if overtimeis required.
Number of employees
20 currently
Additional 10employees will
beemployed for themonth of June
Normal time rate
R32.50 per hour
Overtime rate
30% above normaltime
rate per hour
Hours per unit
3 hours
Required:
1. Calculate the production budgetfor
the quarter.
(3)
2. Calculate the budgeted labourhours per month. Split the hoursbetween normal time
andovertime. (9)
3. Calculate the budgeted labourcost monthly. Split the costbetween normal time and
overtime. (6
Prepare a sales budget for the first quarter (Q1) and the first quarter in total. The...
Prepare a sales budget for the first quarter (Q1) and the first
quarter in total. The selling price per unit is $50.00.
December 50,000/
January 70,000/February 100,000 /March 60,000 / April 100,000
Past experience
shows that 45% of sales are collected in the month of the sale, and
55% in the month following the sale.
2. Prepare a
purchases budget for January through March, and the first quarter
in total. Assume that the company only sells one product that can...
Prepare a sales budget for the first quarter (Q1) and the first quarter in total. The...
Prepare a sales budget for the first quarter (Q1) and the first
quarter in total. The selling price per unit is $50.00.
December of the
previous year 10,000
January
70,000
February
30,000
March
50,000
April
80,000
Past experience
shows that 45% of sales are collected in the month of the sale, and
55% in the month following the sale.
2. Prepare a
purchases budget for January through March, and the first quarter
in total. Assume that the company only...
Our company sells noserings. Please prepare a master budget for the three-month period ending June 30....
Our company sells noserings.
Please prepare a master budget for the three-month period ending
June 30. Include the following detailed budgets (by month and in
total):
Sales budget
Schedule of expected cash collections from sales
Purchases budget (in units and in dollars)
Expected cash disbursements for merchandise purchases
Sales price of product = $10/unit
Actual Sales are as follows:
January $20,000
February $26,000
March $40,000
Budgeted sales:
September $25,000
August $28,000
July $30,000
June $50,000
May $100,000
April $65,000
We...
Our company sells noserings. Please prepare a master budget for the three-month period ending June 30....
Our company sells noserings.
Please prepare a master budget for
the three-month period ending June 30. Include the following
detailed budgets (by month and in total):
Sales budget
Schedule of expected cash collections
from sales
Purchases budget (in units and in
dollars)
Expected cash disbursements for
merchandise purchases
Sales price of product = $10/unit
Actual Sales are as follows:
January $20,000
February $26,000
March $40,000
Budgeted sales:
September $25,000
August $28,000
July $30,000
June $50,000
May $100,000
April $65,000
We...
need to fill this out Income Statement For Month Ending June 17, 2018 Revenues 4100 Computer...
need to fill this out
Income Statement
For Month Ending June 17, 2018
Revenues
4100
Computer & Consulting Revenue
Expenses
5010
Rent Expense
5020
Salary Expense
5030
Advertising Expense
5040
Repairs & Maint. Expense
5050
Oil & Gas Expense
5080
Supplies Expense
5090
Interest Expense
5100
Insurance Expense
5110
Depreciation Expense
Total
Net Income Before Tax
5120
Income Tax Expense (Round to two decimal
places)
Net Income After Tax
this is the data
Transaction
Description of transaction
01.
June 1:...
can you please solve #4 Prepare a sales budget for the first quarter (Q1) and the...
can you
please solve #4
Prepare a sales budget for the first quarter (Q1) and the first
quarter in total. The selling price per unit is $50.00.
December of the
previous year 10,000
January
70,000
February
30,000
March
50,000
April
80,000
Past experience
shows that 45% of sales are collected in the month of the sale, and
55% in the month following the sale.
2. Prepare a
purchases budget for January through March, and the first quarter
in...
. Prepare a cash budget for January through March and for the first quarter in...
. Prepare a cash
budget for January through March and for the first quarter in
total. The company maintains a minimum cash balance of $70,000, and
this was the balance in the cash account on January 1st.
Other expenses include $35,000 per month for rent, $24,000 per
month for advertising, and $66,000 per month for depreciation. In
addition, variable Selling & Administrative cost is $12 per
unit sold, and the company paid a $20,000 dividend in February.
The company...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Young and Company claims that its pressurized diving bell will, on average, maintain its integrity to...
- 1) Alternative compiled code sequence using instructions in classes A, B, C. What is the average...
- An asset is purchased on January 1 for $48,700. It is expected to have a useful...
- Do we have any online or offline tool to convert c and cpp programs into MIPS...
- -what is the pH of HCl 0,1M and NaCl 0,1M mixed together solution? -What is the...
- function X=extractDWT(x_train,startS,endS,wStep,wRange) % x_train = input signal % startS = from second % endS = end...
- Do you agree that Social Loafing is similar to Theory X. Give an example to support...
ADVERTISEMENT