Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

D Tunes is a ballroom studio in Pocatello, Idaho. The studio's owner has collected data regarding the studio's sales for lessons in January 2025 .

image text in transcribedimage text in transcribedimage text in transcribed

D Tunes is a ballroom studio in Pocatello, Idaho. The studio's owner has collected data regarding the studio's sales for lessons in January 2025 . You are interning with them as an accountant. The owner has a series of questions that can be answered using data that has already been given to you. You have already developed the data dictionary and the data model for the data set. D*Tunes Data Dictionary Students \begin{tabular}{ll} \hline Column Name & Field Description \\ \hline StudentID & An ID that uniquely identifles a student. \\ \hline StudentName & A student's name. \\ \hline Level & Student's Skill Level: \\ & B= Beginner \\ & I= Intermediate \\ & A= Advanced \\ \hline Gender & A student's gender. \\ \hline \end{tabular} Lessons \begin{tabular}{ll} \hline Column Name & Field Description \\ \hline LessonID & An ID that uniquely identifles a lesson. \\ \hline Date & The date on which the lesson occurred. \\ \hline Class & The type of class taught during this lesson. \\ \hline Instructor & The ID of the instructor teaching this class. \\ \hline \end{tabular} Participates Column Name Field Description Lesson The ID of the lesson taken by the student. Student The ID of the student taking the lesson. KeyColumnForeignkey For the two salaried employees, D Tunes must withhold the employer portion of FICA taxes every month from their wages. FICA tax is a combination of Social Security tax and Medicare tax. The 2025 FICA tax rate is 7.65\%, which includes Social Security tax of 6.2\% and Medicare tax of 1.45%. The owner does not need to withhold Social Security tax for any earnings above $168,900. Therefore, the studio must only withhold Medicare tax on wages above this amount. Create an information model that will allow you to design a worksheet similar to the one shown that will help the studio determine the FICA tax payments for each month. Upload a Word file that includes your analysis and answers and an Excel file with your calculations. D Tunes is a ballroom studio in Pocatello, Idaho. The studio's owner has collected data regarding the studio's sales for lessons in January 2025 . You are interning with them as an accountant. The owner has a series of questions that can be answered using data that has already been given to you. You have already developed the data dictionary and the data model for the data set. D*Tunes Data Dictionary Students \begin{tabular}{ll} \hline Column Name & Field Description \\ \hline StudentID & An ID that uniquely identifles a student. \\ \hline StudentName & A student's name. \\ \hline Level & Student's Skill Level: \\ & B= Beginner \\ & I= Intermediate \\ & A= Advanced \\ \hline Gender & A student's gender. \\ \hline \end{tabular} Lessons \begin{tabular}{ll} \hline Column Name & Field Description \\ \hline LessonID & An ID that uniquely identifles a lesson. \\ \hline Date & The date on which the lesson occurred. \\ \hline Class & The type of class taught during this lesson. \\ \hline Instructor & The ID of the instructor teaching this class. \\ \hline \end{tabular} Participates Column Name Field Description Lesson The ID of the lesson taken by the student. Student The ID of the student taking the lesson. KeyColumnForeignkey For the two salaried employees, D Tunes must withhold the employer portion of FICA taxes every month from their wages. FICA tax is a combination of Social Security tax and Medicare tax. The 2025 FICA tax rate is 7.65\%, which includes Social Security tax of 6.2\% and Medicare tax of 1.45%. The owner does not need to withhold Social Security tax for any earnings above $168,900. Therefore, the studio must only withhold Medicare tax on wages above this amount. Create an information model that will allow you to design a worksheet similar to the one shown that will help the studio determine the FICA tax payments for each month. Upload a Word file that includes your analysis and answers and an Excel file with your calculations

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

Step: 3

blur-text-image

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

Software Reviews And Audits A How To Guide For Project Staff

Authors: Dr David Tuffley

1st Edition

1461130468, 978-1461130468

More Books

Students also viewed these Accounting questions