Pulling a crate of mass m in kg with a rope by a force of p

Question

Acceleration = a = [P*cos(?) -µ*(M*g - P*sin(?) )]/M

Pulling a crate of mass M (in kg) with a rope by a force of P ( in Newtons) at an angle ? (? is in degrees) and a coefficient of friction µ gives an acceleration of magnitude a (in m/s²). The acceleration due to gravity is denoted by g. Use g = 9.8 m/s².

Part A. Use Excel to creae vertical column of angles ranging from 10 degrees to 35 degrees in increments of 0.5 degrees. Convert these angles to radians in an adjacent column. 1 radian = 57.296 degrees.

Part B. Use Excel to create spreadsheet to determine the acceleration at each of the angles above for P = 650.0N , M= 160 kg, and µ=.39.

Part C. What is the maximum acceleration?

Part D. What is the angle (in degrees) that maximizes the acceleration?