Macy's Inc. is a leading multinational fragrance, skincare, and cosmetics brands company. It is a legitimate...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Macy's Inc. is a leading multinational fragrance, skincare, and cosmetics brands company. It is a legitimate perfumery business that upholds a high aesthetic value, coaxes excellence, and exudes exclusivity, and provides a product range of natural, alcohol-free, and skin-friendly perfumes. In addition to using organic lavender oil as its main raw material, other ingredients are used, such as flowers, fruits, plant materials, musk, and other natural ingredients. Recently, you have been hired by Macy's Inc. as a new management accountant to assist with creating the budget for the company's fragrance product. In the past, the company hasn't done much in the way of budgeting and at specific times of the year, there's been a cash shortfall. In order to prepare a Master Budget for the second quarter, you have been assembled data mentioned the following balances below as of March 31: (b) Actual sales units for the first quarter and budgeted sales units for the following four months are as follows: Additional Information: . Cash Accounts Receivable Accounts Payable Equipment Common Stock Land Retained Earning . . January (Actual February (Actual) March (Actual) April (Budgeted) May (Budgeted) June (Budgeted) July (Budgeted) August (Budgeted) $380,000 $ 420,000 $ 74,000 $175,000 $ 100,000 $1,564,196 $ 50,000 15000 20000 24000 40000 52000 50000 48000 46000 Each unit is being sold for $30. All sales are on credit. Macy's Inc. collects 60% of sales in the month of the sale and 30% in the month after the sale and remaining in the second following month's sales. Bad debts have been negligible. According to management, Macy's Inc.'s ending inventory should equal 20% of the anticipated unit sales for the upcoming month. It is assumed that 24000 units were available inventory as of March 31. Eight grams of organic lavender oil are required per unit of product. Management wants materials on hand at the end of each month equal to 20% of the following month's production. On March 1 Units Units Units Units Units Units Units Units 31, 42000 grams of material in hand. Macy's Inc pays $0.60 as material cost per gram. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month that follows the purchase. First quarter accounts payable are fully paid in the month of April. Macy's requires an hour of direct labor for every unit of a product and the company pays $14 per hour. At Macy's, manufacturing overhead is applied to units of product on the basis of direct labor hours. The variable manufacturing overhead rate is $5 per direct labor hour. Fixed manufacturing overhead is $50,000 per month, which includes $20,000 of noncash costs (primarily depreciation of plant assets). The selling and administrative expense budget is divided into variable and fixed components. The variable selling and administrative expenses are $0.90 per unit sold. Fixed selling and administrative expenses are $70,000 per month. The fixed selling and administrative expenses include $10,000 in costs primarily depreciation that are not cash outflows of the current month. 4. Schedule of expected cash collections. 5. Production Budget 6. Direct Materials Budget Assume that as of April 1, Macy's has a balance of $380,000 in cash and the company need to maintain minimum $500,000 balance at month's end. In case company has shortage of cash, can borrow from the bank and current bank interest rate is 10% per annum. It is assumed that the beginning day of the month would be the day for borrowing, and the last day of the month would be the day for paying back loans. A cash dividend of $32,000 is distributed in April by Macy's Inc and new equipment purchases worth $140,660, paid cash in the month of June. 7. Expected Cash Disbursement for Materials. 8. Direct Labor Budget Required: Using the data above, prepare the following budgets and statements for the second quarter: 1. Budget launch page (Content Page) 2. Beginning balance budget and Budgeting assumptions 3. Sales Budget 9. Manufacturing Overhead Budget 10. Selling And Administrative Expense Budget 11. Cash Budget 12. Prepare a budgeted income statement for the second quarter ending June 30 13. Prepare a budgeted balance sheet as of June 30 Macy's Inc. is a leading multinational fragrance, skincare, and cosmetics brands company. It is a legitimate perfumery business that upholds a high aesthetic value, coaxes excellence, and exudes exclusivity, and provides a product range of natural, alcohol-free, and skin-friendly perfumes. In addition to using organic lavender oil as its main raw material, other ingredients are used, such as flowers, fruits, plant materials, musk, and other natural ingredients. Recently, you have been hired by Macy's Inc. as a new management accountant to assist with creating the budget for the company's fragrance product. In the past, the company hasn't done much in the way of budgeting and at specific times of the year, there's been a cash shortfall. In order to prepare a Master Budget for the second quarter, you have been assembled data mentioned the following balances below as of March 31: (b) Actual sales units for the first quarter and budgeted sales units for the following four months are as follows: Additional Information: . Cash Accounts Receivable Accounts Payable Equipment Common Stock Land Retained Earning . . January (Actual February (Actual) March (Actual) April (Budgeted) May (Budgeted) June (Budgeted) July (Budgeted) August (Budgeted) $380,000 $ 420,000 $ 74,000 $175,000 $ 100,000 $1,564,196 $ 50,000 15000 20000 24000 40000 52000 50000 48000 46000 Each unit is being sold for $30. All sales are on credit. Macy's Inc. collects 60% of sales in the month of the sale and 30% in the month after the sale and remaining in the second following month's sales. Bad debts have been negligible. According to management, Macy's Inc.'s ending inventory should equal 20% of the anticipated unit sales for the upcoming month. It is assumed that 24000 units were available inventory as of March 31. Eight grams of organic lavender oil are required per unit of product. Management wants materials on hand at the end of each month equal to 20% of the following month's production. On March 1 Units Units Units Units Units Units Units Units 31, 42000 grams of material in hand. Macy's Inc pays $0.60 as material cost per gram. The company pays for 40% of its merchandise purchases in the month of the purchase and the remaining 60% in the month that follows the purchase. First quarter accounts payable are fully paid in the month of April. Macy's requires an hour of direct labor for every unit of a product and the company pays $14 per hour. At Macy's, manufacturing overhead is applied to units of product on the basis of direct labor hours. The variable manufacturing overhead rate is $5 per direct labor hour. Fixed manufacturing overhead is $50,000 per month, which includes $20,000 of noncash costs (primarily depreciation of plant assets). The selling and administrative expense budget is divided into variable and fixed components. The variable selling and administrative expenses are $0.90 per unit sold. Fixed selling and administrative expenses are $70,000 per month. The fixed selling and administrative expenses include $10,000 in costs primarily depreciation that are not cash outflows of the current month. 4. Schedule of expected cash collections. 5. Production Budget 6. Direct Materials Budget Assume that as of April 1, Macy's has a balance of $380,000 in cash and the company need to maintain minimum $500,000 balance at month's end. In case company has shortage of cash, can borrow from the bank and current bank interest rate is 10% per annum. It is assumed that the beginning day of the month would be the day for borrowing, and the last day of the month would be the day for paying back loans. A cash dividend of $32,000 is distributed in April by Macy's Inc and new equipment purchases worth $140,660, paid cash in the month of June. 7. Expected Cash Disbursement for Materials. 8. Direct Labor Budget Required: Using the data above, prepare the following budgets and statements for the second quarter: 1. Budget launch page (Content Page) 2. Beginning balance budget and Budgeting assumptions 3. Sales Budget 9. Manufacturing Overhead Budget 10. Selling And Administrative Expense Budget 11. Cash Budget 12. Prepare a budgeted income statement for the second quarter ending June 30 13. Prepare a budgeted balance sheet as of June 30
Expert Answer:
Answer rating: 100% (QA)
Budget Launch Page Macys Inc Master Budgets for the Second Quarter This report contains the master budgets for Macys Inc for the second quarter of the year consisting of the months of April May and Ju... View the full answer
Related Book For
Managerial Accounting
ISBN: 9780073526706
12th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these accounting questions
-
LLJ Satellites: Variance Analysis and Budgeting Jack Childs is nervous about his company's future performance. The Childs family own 40% of the shares of LLJ Satellites, and generally has control...
-
As a recent graduate, you have been hired by Canadian Communications Inc. (CCI), a large industry leader in the Canadian telecommunications market. CCI is contemplating investing in an upgraded...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
If the resultant force acting on the hook is F R = {? 200i + 800j + 150k} lb, determine the magnitude and coordinate direction angles of F. 30 F= 600 ib
-
Reveille, Inc. purchased Machine #204 on April 1, 2007 and placed the machine into production on April 3, 2007. The following information is relevant to Machine #204: Price ......................
-
Evaluate each exponential expression in Exercises 122. -26
-
On April 20, 1992, Daniel Hubbard (plaintiff), a potato farmer, and UTZ Quality Foods, Inc. (UTZ) (defendant), a potato chip manufacturer, entered an installment contract under which Hubbard agreed...
-
Sovereign Millwork, Ltd., produces reproductions of antique residential moldings at a plant located in Manchester, England. Since there are hundreds of products, some of which are made only to order,...
-
(a) Use the method of direct Integration to find the solution of x2. (b) (i) dy -4x=6. (5%) dx Verify that y = ex, y = e3x and y = Aex + Be -3x (A and B are constants) are - 6y= 0. (10 %) solutions...
-
It is January 2 and Twin Pines Farm is putting together its annual net worth statement Following are a nurmher of pieces of information they have collected. Help them fit it all together using the...
-
For each real value of k, the equation y = kx-1/3defines a family of curves in the xy-plane. Find an algebraic equation that defines the family of curves which are orthogonal to the given family.
-
Explain how to develop improvement capability for organizational performance
-
Write a C program using Bubble Sort that allows the user to enter a number of arbitrary integers in any order, stores them in an array, and sorts them in the non-decreasing order. Note that your...
-
The sales manager purposely overestimates the selling price at budgeting time in order to "look good" when the actual numbers come in. This is an example of ?
-
Consider the following two stocks and T-Bill: Security A B T-Bill a. Expected return 12% 9% 2% O Price Per Share 30% $100 20% $75 0% PAB (Correlation) 0.8 Suppose you buy 50 shares of stock A and 50...
-
How do trade and investment dynamics intricately influence both the trajectory of economic development, encompassing factors such as productivity enhancements, market access, specialization, and...
-
Problem 18.2. Prove that 1+3+5+...+(2n-1)= n for every positive integer n, using the principle of mathematical induction.
-
Nitrogen monoxide reacts with hydrogen as follows: 2NO(g)+ H2(g) N2O(g) + H2O(g) The rate law is [H2]/ t = k[NO]2[H2], where k is 1.10 107 L2/(mol2s) at 826oC. A vessel contains NO and H2 at...
-
Barker Company has a single product called a Zet. The company normally produces and sells 80,000 Zets each year at a selling price of $40 per unit. The company's unit costs at this level of activity...
-
Under what conditions would it be appropriate to us a process costing system?
-
What is a self-imposed budget? What are the major advantages of self-imposed budgets? What caution must be exercised in their use?
-
For the following op-amp circuit derive the algebraic expression for the output voltage \(v_{o}\) in terms of the two input voltages \(v_{1}(t)\) and \(v_{2}(t)\). Indicate what mathematical...
-
(a) For the following op-amp circuit derive the input-output differential equation relating the output voltage \(v_{o}\) and the input voltage \(v_{i}(t)\). (b) Derive the circuit's State-Variable...
-
Consider the following op-amp circuit where the output is voltage \(v_{o}(t)\) and the input is voltage \(v_{i}(t)\). (a) Choose a set of state variables and justify your choice. (b) Obtain the...
Study smarter with the SolutionInn App