Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Can someone assist with A-J thank you Portraits Ualimited Cormpony Hodertinu Prolect Ian Jeraings, presideet of Pertnaits Unl -ited Cacmany, was just concluting a budget

image text in transcribed

image text in transcribed

image text in transcribed

Can someone assist with A-J thank you

Portraits Ualimited Cormpony Hodertinu Prolect Ian Jeraings, presideet of Pertnaits Unl -ited Cacmany, was just concluting a budget meeting with his senior staff. It wat Niovember of 2022 , and the sroup was discussing preparativa of the firm's masier becket for 2023 . Tve decided to go ahcad and purchase the inductral robot we've beea talking aboet. We'il make the acquisition on January 3 of nect year, and I expect it will take most of the yeat to train the persomel and reorganize the production grocess to take full advastage of the sew equipment." In response to a qaestion about finaneing tec aceavition, Jenninger replicd as follows: "The robot will cest 5250,000 . There will aha be an aditionat 550,100 in ancillary equipenent to be parchased. We'll finance these purchases with a cocyear 5300,000 loan from Shark Bank and Trust Compaty en January 2. I ve negotiated a reptyment schedule of four equal installments en the last day of cach quartar. The interrut rast will be to percent per annum on the redocing balasce basis, and interest paymeetn will be cuartctly as well. "With that the meeting broke up, and the hudget poocess was en. Portaits Unlimited Company is a manufacturer ef metal picture Peetraits. The firm's two product lines are designated as S (umall Portraits; 57 incthei) and L (lage Portraits; 810 inches). The primary raw maserials are fleckitie metal strips and 9-inch by 24-inch glass aheets. Each S Postrait requires a 2-foot metal strip, and an L. Portrair requires a 3-foot atrip. Allowing for normal breakage and scrap glavs, the contpayy can get either four 5 Portraits of two L Portraits out of a glass sheet. Other raw naterials, sach as cardhoard bocking, are insignificant in cost and are treated as indirect maserials. Jane Wyitians, Portraits Unlimited't controller is in charge of preparing the naster bodget for 2023. She bas gathered the followieg infomation: 1. Sales in the fourth qeater of 2022 are cepected to be 50,0005 Fortraits and 40,000L Portraits. The sales manager predicts that over the neat two ycan, sales in each prodact line will grow by 5.000 units each qaanter over the previoes quarter. For coample, $ Portraits sales ia fint quarter of 2023 are expected to be 55,000 units. 2. Portraits Lalienited Company sales history indicates the 60 percent of all sales are on credit, with the senainder of the sales in cach. The conpany's collection erperience shows that so percent of the credit sales are collected daring the quiter in which the alle is mude, while the remeining 20 percent is collecied in the following curser. 3. The S Portrait sells for 510, and the L. Pertrair sells far 515. Theie peices are expected to hold constant throughent 2023 . 4. The production manager actempea to end cach quarser with enough fieished goeds inventory in each prodoct line to cover 20 percent of the following quarter's sales. Moceover, an antompt is made to end exch quater with 20 percent of the glass theets needed for the following quanter's prodaction. Assumet an eoding inventary of glass abcets of 20,400 for the fourth quanter of 2023 Metal strips are purchased locally, the conpany beye them cn a just-in-tiene batic inventory is negigible. The opening inventory for quacter 4, 2022 for both finialied poods and raw materials can be found by determining the desired ending ievensory for zuarter 3, 3022 hased on the ieventary prinsiple purvided. 5. Als direct-material purthases aes made ve acewent, asas 90 petcent of each quater's peid in the nexl quariet. 6. Indiecet materials afe parthased with cabb as needed. Work in-procets is neytigible. 7. The following manufacturing overhead cents are budgeted for 2023 : 8. Projected matufacturing costs in 2023 are as follows: 9. The followiag relates to pass selling and adninistrative expenses. (Uhe regression analysis to derive a cost function and we thir cont fastion to estimate the selling and administrative costh. 10. Jacksen anticipates that dividend of $0,000 will be declared and paid in eaxh each qaarter. 11. Pertraiss Unlimised Company jeojected belece ahret as of December 31, 2022, follows: equired: repare Portraits Unlimited Company master budget for each quarter of 2023 and in total for ear by completing the following budgets and schedules: (a) Sales budget (prepare 4th quarter of 2022 as well). (8 marks) (b) Schedule of cash collected from customers. (101/2 marks) (c) Production budget (prepare 4th quarter of 2022 as well). (19 marks) (d) Direct-material budget (prepare 4th quarter of 2022 as well). (191/2 marks) (e) Schedule of cash disbursement to suppliers for direct material. (f) Direct labour budget. (3 marks) (g) Manufacture overhead budget. (4 marks) (h) Selling and administrative budget. (Round off variable cost to 2 decimal places and fixed cost to the nearest whole number). Show regression computation. (5 marks) (i) Cash budget (151/2 marks) (j) Portraits Unlimited Company Budgeted Cost of Goods Manufactured and Sold for the year 2023. (Show budget for the entire year only). (9 marks) Portraits Ualimited Cormpony Hodertinu Prolect Ian Jeraings, presideet of Pertnaits Unl -ited Cacmany, was just concluting a budget meeting with his senior staff. It wat Niovember of 2022 , and the sroup was discussing preparativa of the firm's masier becket for 2023 . Tve decided to go ahcad and purchase the inductral robot we've beea talking aboet. We'il make the acquisition on January 3 of nect year, and I expect it will take most of the yeat to train the persomel and reorganize the production grocess to take full advastage of the sew equipment." In response to a qaestion about finaneing tec aceavition, Jenninger replicd as follows: "The robot will cest 5250,000 . There will aha be an aditionat 550,100 in ancillary equipenent to be parchased. We'll finance these purchases with a cocyear 5300,000 loan from Shark Bank and Trust Compaty en January 2. I ve negotiated a reptyment schedule of four equal installments en the last day of cach quartar. The interrut rast will be to percent per annum on the redocing balasce basis, and interest paymeetn will be cuartctly as well. "With that the meeting broke up, and the hudget poocess was en. Portaits Unlimited Company is a manufacturer ef metal picture Peetraits. The firm's two product lines are designated as S (umall Portraits; 57 incthei) and L (lage Portraits; 810 inches). The primary raw maserials are fleckitie metal strips and 9-inch by 24-inch glass aheets. Each S Postrait requires a 2-foot metal strip, and an L. Portrair requires a 3-foot atrip. Allowing for normal breakage and scrap glavs, the contpayy can get either four 5 Portraits of two L Portraits out of a glass sheet. Other raw naterials, sach as cardhoard bocking, are insignificant in cost and are treated as indirect maserials. Jane Wyitians, Portraits Unlimited't controller is in charge of preparing the naster bodget for 2023. She bas gathered the followieg infomation: 1. Sales in the fourth qeater of 2022 are cepected to be 50,0005 Fortraits and 40,000L Portraits. The sales manager predicts that over the neat two ycan, sales in each prodact line will grow by 5.000 units each qaanter over the previoes quarter. For coample, $ Portraits sales ia fint quarter of 2023 are expected to be 55,000 units. 2. Portraits Lalienited Company sales history indicates the 60 percent of all sales are on credit, with the senainder of the sales in cach. The conpany's collection erperience shows that so percent of the credit sales are collected daring the quiter in which the alle is mude, while the remeining 20 percent is collecied in the following curser. 3. The S Portrait sells for 510, and the L. Pertrair sells far 515. Theie peices are expected to hold constant throughent 2023 . 4. The production manager actempea to end cach quarser with enough fieished goeds inventory in each prodoct line to cover 20 percent of the following quarter's sales. Moceover, an antompt is made to end exch quater with 20 percent of the glass theets needed for the following quanter's prodaction. Assumet an eoding inventary of glass abcets of 20,400 for the fourth quanter of 2023 Metal strips are purchased locally, the conpany beye them cn a just-in-tiene batic inventory is negigible. The opening inventory for quacter 4, 2022 for both finialied poods and raw materials can be found by determining the desired ending ievensory for zuarter 3, 3022 hased on the ieventary prinsiple purvided. 5. Als direct-material purthases aes made ve acewent, asas 90 petcent of each quater's peid in the nexl quariet. 6. Indiecet materials afe parthased with cabb as needed. Work in-procets is neytigible. 7. The following manufacturing overhead cents are budgeted for 2023 : 8. Projected matufacturing costs in 2023 are as follows: 9. The followiag relates to pass selling and adninistrative expenses. (Uhe regression analysis to derive a cost function and we thir cont fastion to estimate the selling and administrative costh. 10. Jacksen anticipates that dividend of $0,000 will be declared and paid in eaxh each qaarter. 11. Pertraiss Unlimised Company jeojected belece ahret as of December 31, 2022, follows: equired: repare Portraits Unlimited Company master budget for each quarter of 2023 and in total for ear by completing the following budgets and schedules: (a) Sales budget (prepare 4th quarter of 2022 as well). (8 marks) (b) Schedule of cash collected from customers. (101/2 marks) (c) Production budget (prepare 4th quarter of 2022 as well). (19 marks) (d) Direct-material budget (prepare 4th quarter of 2022 as well). (191/2 marks) (e) Schedule of cash disbursement to suppliers for direct material. (f) Direct labour budget. (3 marks) (g) Manufacture overhead budget. (4 marks) (h) Selling and administrative budget. (Round off variable cost to 2 decimal places and fixed cost to the nearest whole number). Show regression computation. (5 marks) (i) Cash budget (151/2 marks) (j) Portraits Unlimited Company Budgeted Cost of Goods Manufactured and Sold for the year 2023. (Show budget for the entire year only). (9 marks)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Auditing

Authors: A. Pandu

1st Edition

8189630822, 978-8189630829

More Books

Students explore these related Accounting questions