Question

Question 5: Master Budgeting • Time: 30 minutes • Total: 16 marks Guava Inc. has the following information: Month February Ma
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Guava Inc.,
Purchase Budget
April May June Quarter
Budgeted cost of goods sold $35700 $28000 $49000 $112700
Add: Desired ending inventory 8400 14700 15120 15120
Inventory needed 44100 42700 64120 127820
Less: Beginning inventory -10710 -8400 -14700 -10710
Required purchases $33390 $34300 $49420 $117110

Calculation of Cost of goods sold

April= $51000*70%= $35700

May= $40000*70%= $28000

June= $70000*70%= $49000

Calculation of Desired ending inventory

April= $40000*70%*30%= $8400

May= $70000*70%*30%= $14700

June= $72000*70%*30%= $15120

Calculation of Beginning inventory

April= $51000*70%*30%= $10710

Add a comment
Know the answer?
Add Answer to:
Question 5: Master Budgeting • Time: 30 minutes • Total: 16 marks Guava Inc. has the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Question 5: Master Budgeting • Time: 30 minutes • Total: 16 marks Guava Inc. has the...

    Question 5: Master Budgeting • Time: 30 minutes • Total: 16 marks Guava Inc. has the following information: coas inventoglie Month February March April Budgeted Sales $60,000 51,000 40,000 70,000 72,000 - 4260 35700 28000 - 49000 - Soloo 1400 15120 May June In addition, the cost of goods sold rate is 70% and the desired inventory level is 30% of next month's cost of sales. Required: Prepare a purchases budget for April through June and summarize the total purchases...

  • sales Question 5: Master Budgeting • Time: 30 minutes • Total: 16 marks ending invento is...

    sales Question 5: Master Budgeting • Time: 30 minutes • Total: 16 marks ending invento is 30% of Gob Net Guava Inc. has the following information: Month February March Budgeted Sales $60,000 51,000 40,000 70,000 72,000 April May June In addition, the cost of goods sold rate is 70% of previous month and the desired ending inventory level is 30% of next month's cost of sales. open eventy for month of April 10710 Required: Prepare a purchases budget for April...

  • Question 6: Master Budgeting • Time: 40 minutes Total: 24 marks The following information pertains to...

    Question 6: Master Budgeting • Time: 40 minutes Total: 24 marks The following information pertains to Stark Corporation Jan Feb Mar Apr May June $30,000 34,000 38.000 42.000 48.000 60,000 $10,000 12.000 14.000 16.000 18.000 20,000 Cash is collected from customers in the following manner 30% Month of sale Month following sale Two months following sale Amount uncollectible SOX 15% 5% * Customers paying in the month of sale receive a 2% cash discount. 40% of purchases are paid for...

  • Required: Prepare a master budget for the three-month period ending June 30. Include the following detailed...

    Required: Prepare a master budget for the three-month period ending June 30. Include the following detailed schedules: 1. a. A sales budget, by month and in total. b. A schedule of expected cash collections, by month and in total. c. A merchandise purchases budget in units and in dollars. Show the budget by month and in total. d. A schedule of expected cash disbursements for merchandise purchases, by month and in total. 2. A cash budget. Show the budget by...

  • PROBLEM 8-29 Completing a Master Budget LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, L08-10 The following data relate...

    PROBLEM 8-29 Completing a Master Budget LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, L08-10 The following data relate to the operations of Shilow Company, a wholesale distributor of cor- sumer goods: Current assets as of March 31: $8,000 Cash $20,000 Accounts receivable Inventory.... . $36,000 $120,000 $21,750 Bulding and equipment, net. Accounts payable. . Common stock. Retained earnings. $150,000 $12,250 The gross margin is 25% of sales. a. Master Budgeting Actual and budgeted sales data March lactua $50,000 $60,000 $72.000 590.000 $48.000...

  • need 1-4 answered! please help! 2) Schedule of expected cash collections: April May Jun Total sha...

    need 1-4 answered! please help! 2) Schedule of expected cash collections: April May Jun Total sha Tootections .. Nordic Cerpeny, a merchandising company pre- pares its master budget un quarterly base. The following data Save been assembled to Assist in preparation of the master budget for the second quarter. 2. As of March 31 (the end of the prior quare), the company's balance sheet showed the following account balances: June May $1,000 Total Accounts Receivable : Imory HERE ** Plant...

  • The Master Budget 555 PROBLEMS Group A P9-54A Comprehensive budgeting problem (Le Damon Manufacturing is preparing...

    The Master Budget 555 PROBLEMS Group A P9-54A Comprehensive budgeting problem (Le Damon Manufacturing is preparing its master budget for the first que budgeting problem (Learning Objectives 2 & 3) ing year. The following data pertanto s preparing its master budget for the first quarter of the upcom- u facturing's operations Current Assets as of December 31 (prior year): Cash.. $ 4,600 Accounts receivable, net $ 46,000 Inventory $ 15,600 Property, plant, and equipment, net $121,000 Accounts payable. $ 43,000...

  • Master Budgeting Project Please Help :(

    You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...

  • master budgeting

    Maleeq Enterprise prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparing the master budget for the first quarter: a.    As of 31st December, the company’s trial balances showed the following: AccountsDebit (RM)Credit (RM)Cash48,000Accounts   Receivable224,000Inventory60,000Premises370,000Accounts payable93,000Common Stock500,000Retained Earnings109,000702,000702,000 b.    Actual sales for December and budgeted sales for the next four months are as follows:December (actual)RM 280,000JanuaryRM 400,000FebruaryRM 600,000MarchRM 300,000AprilRM 200,000 c.     Sales are 20% for cash and 80% on credit. All payments on credit...

  • 28 2) Sche ACC 321 Group Project (chapter 6) for a Merchandising ompany 3) 1 Retained...

    28 2) Sche ACC 321 Group Project (chapter 6) for a Merchandising ompany 3) 1 Retained Earnings ....*** * June ....... July Nordic Company, a merchandising company, pre- pares its master budgme un quarterly basis. The following data have been assembled to assist in preparation of the master budget for the second quarter. 2. As of March 31 (the end of the prior quarter), the company's balance sheet showed the following account balances: Cash .................... $ 9,000 Accounts Receivable .............

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT