{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-06-28T03:45:09-04:00", "answer_date": "2024-06-28 03:45:09", "is_docs_available": null, "is_excel_available": null, "is_pdf_available": null, "count_file_available": 0, "main_page": "student_question_view", "question_id": "4234052", "url": "\/study-help\/questions\/plz-use-excel-and-be-detailed-petra-co-produces-4234052", "question_creation_date_js": "2024-06-28T03:45:09-04:00", "question_creation_date": "Jun 28, 2024 03:45 AM", "meta_title": "[Solved] PLZ use excel and be detailed Petra & Co. | SolutionInn", "meta_description": "Answer of - PLZ use excel and be detailed Petra & Co. produces camping refrigerators. The plan for the next four months is the fol | SolutionInn", "meta_keywords": "plz,excel,detailed,petra,produces,camping,refrigerators,plan,four,months,company,plans", "question_title_h1": "PLZ use excel and be detailed Petra & Co. produces camping refrigerators. The plan for the next four months is the following: The company plans", "question_title": "PLZ use excel and be detailed Petra & Co. produces camping refrigerators.", "question_title_for_js_snippet": "PLZ use excel and be detailed Petra Co produces camping refrigerators The plan for the next four months is the following The company plans to sell 50,000 units per month for April, May, and June, and 40,000 units for March of 2021 The selling price will be set at $45 per unit It is planned that Finished Goods inventory on March 1 will be 12,000 units at $279,375 The company follows a policy requiring ending finished goods inventory each month to be 30 of next month's sales There is no WIP The inventory of raw materials on March 1 was 12,900kg The policy is that the ending inventory amounts to 15 of next month's production requirements The company plans $55,000 of selling administrative expenses (including $12,000 of depreciation) plus 5 of sales for commissions Additional data relating to manufacturing costs for April 2021 is as below Direct Materials 2 kg per unit $14 per kg Direct Labour (DLH) 15 minutes per unit $25 per hour Variable Manufacturing Overhead allocated $4 per DLH Budgeted fixed manufacturing overhead is $104,000 (based on practical capacity of 52,000 units per month) and excludes $40,000 of depreciation REQUIRED 1 Prepare the following budgets for March and April 2021 (5 marks) (i) Production Budget ii) Material Purchases Budget 2 In March 2021, the manager decides the business needed to have the security of a three month loan of $200,000 starting on 1 April 2021 as its cash balance has been diminished because of recent equipment upgrades The interest rate for the loan will be 9 per 3 The Board of Directors of Petra and Co is concerned that the use of participative annum repaid monthly commencing on 30 April 2021 The principal is paid at the end budgeting and the provision of monetary bonus incentives for production and sales of the three month term To consider the loan application, the bank requested the managers that achieve their budgeted levels of profit has resulted in the company's provision of a number of budgets for April including the Cash Budget All sales are budgets being underestimated They believe the targets seemed to be met with case made on credit and customers pay 40 in the month of sale 58 in the month What are the issues Discuss the issues briefly and provide one recommendation to following The remaining 2 is uncollectable address the issues (3 marks) Assume that materials are paid 65 in the month purchased and 35 in the following month Labour and relevant overhead costs are paid in the month the liability is incurred Selling and administration expenses are paid each month as incurred, except for commissions that are paid in the subsequent month The opening cash balance at 1 April (before the loan drawdown) is planned to be $30,190 Assume the short term loan has been secured, prepare the Cash Budget for the month of April, 2021 (7 marks)", "question_description": "

PLZ use excel and be detailed<\/p>

<\/p>

\"image<\/div><\/div><\/div> Petra & Co. produces camping refrigerators. The plan for the next four months is the following: The company plans to sell 50,000 units per month for April, May, and June, and 40,000 units for March of 2021. The selling price will be set at $45 per unit. It is planned that Finished Goods inventory on March 1 will be 12,000 units at $279,375. The company follows a policy requiring ending finished goods inventory each month to be 30% of next month's sales. There is no WIP. The inventory of raw materials on March 1 was 12,900kg. The policy is that the ending inventory amounts to 15% of next month's production requirements. The company plans $55,000 of selling & administrative expenses (including $12,000 of depreciation) plus 5% of sales for commissions. Additional data relating to manufacturing costs for April 2021 is as below: Direct Materials 2 kg per unit @ $14 per kg Direct Labour (DLH) 15 minutes per unit @ $25 per hour Variable Manufacturing Overhead allocated @$4 per DLH Budgeted fixed manufacturing overhead is $104,000 (based on practical capacity of 52,000 units per month) and excludes $40,000 of depreciation. REQUIRED: 1. Prepare the following budgets for March and April 2021: (5 marks) (i) Production Budget ii) Material Purchases Budget 2. In March 2021, the manager decides the business needed to have the security of a three- month loan of $200,000 starting on 1 April 2021 as its cash balance has been diminished because of recent equipment upgrades. The interest rate for the loan will be 9% per 3. The Board of Directors of Petra and Co. is concerned that the use of participative annum repaid monthly commencing on 30 April 2021. The principal is paid at the end budgeting and the provision of monetary bonus incentives for production and sales of the three-month term. To consider the loan application, the bank requested the managers that achieve their budgeted levels of profit has resulted in the company's provision of a number of budgets for April including the Cash Budget. All sales are budgets being underestimated. They believe the targets seemed to be met with case. made on credit and customers pay 40% in the month of sale; 58% in the month What are the issues? Discuss the issues briefly and provide one recommendation to following. The remaining 2% is uncollectable. address the issues. (3 marks) Assume that materials are paid 65% in the month purchased and 35% in the following month. Labour and relevant overhead costs are paid in the month the liability is incurred. Selling and administration expenses are paid each month as incurred, except for commissions that are paid in the subsequent month. The opening cash balance at 1 April (before the loan drawdown) is planned to be $30,190. Assume the short-term loan has been secured, prepare the Cash Budget for the month of April, 2021. (7 marks)", "transcribed_text": "", "related_book": { "title": "Global Strategy", "isbn": "0357512367, 978-0357512364", "edition": "5th Edition", "authors": "Mike W. Peng", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/649592eaa157d_32303.jpg", "uri": "\/textbooks\/global-strategy-5th-edition-9780357512364", "see_more_uri": "" }, "free_related_book": { "isbn": "3986085998", "uri": "\/textbooks\/the-professional-handbook-on-chasing-wealth-what-you-must-understand-when-seeking-wealth-1st-edition-978-3986085995-257669", "name": "The Professional Handbook On Chasing Wealth What You Must Understand When Seeking Wealth", "edition": "1st Edition" }, "question_posted": "2024-06-28 03:45:09", "see_more_questions_link": "\/study-help\/questions\/business-marketing-2022-June-08", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/for-many-cities-around-the-world-garbage-is-an-increasing", "description": "For many cities around the world, garbage is an increasing problem. Many North American cities have virtually run out of space to dump the garbage. A consultant for a large American city decided to...", "stars": 3 }, { "url": "\/study-help\/psychology\/2-confront-selfdefeating-failureavoiding-strategies-directly-1984679", "description": "2. Confront self-defeating, failure-avoiding strategies directly.", "stars": 3 }, { "url": "\/below-are-the-titles-of-number-of-debit-and-credit-accounts-as-they-might", "description": "Below are the titles of a number of debit and credit accounts as they might appear on the balance sheet of Hayduke Corporation as of October 31, 2012. Instructions Select the current asset and...", "stars": 3 }, { "url": "\/study-help\/questions\/varmitbgone-is-a-pest-control-service-that-operates-in-a-9841481", "description": "Varmit-B-Gone is a pest control service that operates in a suburban neighborhood. The company attempts to make service calls at least once a month to all homes that subscribe to its service. It makes...", "stars": 3 }, { "url": "\/study-help\/questions\/the-var-of-a-banks-trading-portfolio-has-been-estimated-5822258", "description": "The VaR of a bank's trading portfolio has been estimated at $125,000. It is assumed that the daily earnings are independently and normally distributed. What is the 5-day VaR?", "stars": 3 }, { "url": "\/study-help\/questions\/211-lab-importing-packages-import-the-necessary-modules-and-read-790695", "description": "2.11 LAB: Importing packages Import the necessary modules and read in a csv file. The homes dataset contains 18 features giving the characteristics of 76 homes being sold. The modules will be used...", "stars": 3 }, { "url": "\/study-help\/questions\/if-a-byte-is-written-to-an-ecc-memory-module-792146", "description": "If a byte is written to an ECC memory module that has four-bit values set to 1, and four set to 0, which type of parity information will be used?", "stars": 3 }, { "url": "\/study-help\/questions\/a-client-has-expressed-concern-about-schema-changes-occurring-without-792342", "description": "A client has expressed concern about schema changes occurring without their data platform team's knowledge. Which step in proactive data observability helps detect this issue?", "stars": 3 }, { "url": "\/study-help\/questions\/generate-a-publicprivate-key-pair-and-use-the-private-key-792348", "description": "Generate a public\/private key pair and use the private key to encrypt the message \"Hello Professor\". Use the tool and instruction at https:\/\/cryptotools.net\/rsagen or any other key generator.", "stars": 3 }, { "url": "\/study-help\/questions\/a-wellinsulated-2m-3-rigid-tank-contains-saturated-ammonia-at-792674", "description": "A well-insulated 2-m 3 rigid tank contains saturated ammonia at 40 C. Initially, the tank contains 50% (volume based) of this ammonia in liquid form and the rest (50%) in vapor form. The valve (on...", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/bu-5525-corporation-is-a-us-based-company-that-prepares-4234051", "next": "\/study-help\/questions\/etech-initiatives-limited-plans-to-issue-500000-10year-4-percent-4234053" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Business", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/business" }, { "name": "Accounting", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/business-accounting" }, { "name": "PLZ use excel and be detailed Petra & Co. produces camping refrigerators.", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/plz-use-excel-and-be-detailed-petra-co-produces-4234052" } ], "skill_details": { "skill_id": "9", "skill_name": "Accounting", "parent_id": "1" } }d": "1" } }